$$Excel-Macros$$ Require help on Bubble Chart for additional dimension

Hi group, Greetings! Please refer the attached excel sheet. We know that a bubble chart is a three dimensional chart, X, Y and bubble size. I want to add one more dimension to it (one more factor). This will be represented by a specific colour of the each bubble. For example, 1 represents red bubbl

Re: $$Excel-Macros$$ Excel macro delete columns - starting row 23

Sheets("Sheet1").Range("a23:a65536").EntireRow.Delete where "Sheet1" is Name of Sheet -- *Arif Mansoorali Massani Gujarat, India* On Wed, Aug 11, 2010 at 7:55 PM, dii jii wrote: > Hi, > Would like to get a piece of code ( excel macro) to delete Columns > starting row 23.. This is where my

Re: $$Excel-Macros$$ if iteration

Hi Angelo, I'm still confused about exactly what you want. Are you really sure you're looking for an iteration? You say that If in cell A1 i have "aaa" it should stay the same, but if i have "bbb" it should be changed to "ccc" , but cell A1 *has* "aaa" or * displays* "aaa"? - If it has "aaa", then

Re: $$Excel-Macros$$ if iteration

Dear Bruno, Thanks for the feedback. If in cell A1 i have "aaa" it should stay the same, but if i have "bbb" it should be changed to "ccc". Regards 2010/8/11 Bruno Bruno > Hi, > I am not pretty sure of what you want, but aren't you looking for a simple > formula? Something like: > > =IF(MOD(

$$Excel-Macros$$ Re: Bring in all matched unique values using lookup

I really would like to do this using a formula or code instead of filter or pivot. Let me just explain again and you will understand formula makes much better sense. Basically, what I really want to do is have a drop down listing of all 50 states where the user will pick a state and than you will

Re: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

Hi Noorain, Vlookup cant do this.. However u can use the Offset and Match formula combination to do this.. The following link has the solution... Look at the section "Left Lookups" http://www.cpearson.com/excel/TablesAndLookups.aspx Regards, Andy On Wed, Aug 11, 2010 at 2:46 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ Help for Pick data from access to Excel

Thanx Ramkesh.. but its not..what i wanti explain..what i do...i have 6lac data in access with all details...and on daily basis i have reced. some mobile nos and after that i check all detail in access with running query..after running query..output copy and paste in excel on front of that mob

$$Excel-Macros$$ Excel macro delete columns - starting row 23

Hi, Would like to get a piece of code ( excel macro) to delete Columns starting row 23.. This is where my headers start. I don't want include the entire column, i ahve some data above row 23. Thanks in advance. Jimmy -- ---

Re: $$Excel-Macros$$ Date addition

Dear balbir, You can use EOMONTH function.. =EOMONTH(DATE,No. of Month) Thanks, Noorain On Wed, Aug 11, 2010 at 4:44 PM, balbirkumar . wrote: > > Dear Friends, > > I want to add months to data which is in date format. > please suggest me the way out. > I have got data in date format as 25/

Re: $$Excel-Macros$$ For Separate words from Capital letters

a dedicated "search" you have 72 names to search for if then else 72 "if thens" and iterate your loops for next one to 72 On Wed, Aug 11, 2010 at 8:41 AM, Raj Kumar wrote: > Hi, > > This is a attachment. I want to separate words on the base of Capital > Letter so kind suggest me that how can we

Re: $$Excel-Macros$$ Lookup Problem

Dear Kalyan, Please see attached sheet..Most Probably your problem has been solved Thanks, Noorain noorain.ans...@gmail.com 9911176564 On Wed, Aug 11, 2010 at 4:26 PM, Kal xcel wrote: > Hi, > > I have this data in a sheet > > *Depot Name* *BP Name - Report* > Ahmedabad H K Sales

$$Excel-Macros$$ For Separate words from Capital letters

Hi, This is a attachment. I want to separate words on the base of Capital Letter so kind suggest me that how can we separate this records. Regards Raj Bharti -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Lookup Problem

Hi Kalyan pls use Pivot table u can see like the date below. Count of BP Name - Report Depot Name BP Name - Report Total Ahmedabad H K Sales Agency - Sanand 1 Parshwa Traders - Gandhinagar 1 Soham Agency - Chikhli 1 Ahmedabad Total 3 Ambala Chaman Traders - Ambala 1 Happy Traders

Re: $$Excel-Macros$$ Splitting cell contents into multple rows

Thanks for replying sudhir, I understand your suggestion. But I was looking for a macro solution to it. Because sometimes the data may cross to thousands of rows and then it becomes very difficult to do it manually. Regards, Bikram --

Re: $$Excel-Macros$$ if iteration

Hi, I am not pretty sure of what you want, but aren't you looking for a simple formula? Something like: =IF(MOD(CODE(A1);2)=1;A1;REPT(CHAR(CODE(A1)+1);3)) Where A1 is the cell with "aaa" On Tue, Aug 10, 2010 at 6:23 PM, Angelo Spinola wrote: > Hello, > > > How can i create and iteration for: >

RE: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

Hi, No. VLOOKUP only works left to right. If you want to work right to left, you have to use Index / Match Regards - Dave Date: Wed, 11 Aug 2010 14:46:31 +0530 Subject: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula.. From: noorain.ans...@gmail.com To: excel-macros@googlegr

RE: $$Excel-Macros$$ Date addition

Hi, If you have the Analysis Tool Pack loaded, use EDATE. It's very straight-forward. If your date is in A1, then in another cell: =EDATE(A1,50). Format using a Date fromat. If you don't have it loaded, it comes with XL. Tools menu, Add-ins, tick Analysis Toolpack. Regards - Dave. Date:

$$Excel-Macros$$ Date addition

Dear Friends, I want to add months to data which is in date format. please suggest me the way out. I have got data in date format as 25/06/2008 and i want to add 50 months to this date. Please advise With Thanks & Regards -- Balbir Kumar --

$$Excel-Macros$$ Lookup Problem

Hi, I have this data in a sheet *Depot Name* *BP Name - Report* Ahmedabad H K Sales Agency - Sanand Ahmedabad Parshwa Traders - Gandhinagar Ahmedabad Soham Agency - Chikhli Ambala Chaman Traders - Ambala Ambala Shiv Trading Company - Assandh Ambala Happy Traders - Barara Ambala R. K. Gene

$$Excel-Macros$$ Can we find left Value through VLOOKUP formula..

Dear Experts, Can we find left Value through VLOOKUP formula..Please need your co-operation.. Example... I want to find Emp Name behalf of Emp ID through only VLOOKUP. Emp Name Emp ID Noorain 22330 Sunil 22331 -- Thanks & regards, Noorain Ansari noorain.ans...@gmail.com --

Re: $$Excel-Macros$$ Splitting cell contents into multple rows

Hi Practice Practice, Open the file in Excel. You will find all the information autofit the data Select all and then Use Text To Columns Feature in Excel. Choose the Delimited option. And the the Next Screen you will have a place to type a customized delimiter. Type the Pipe symbol in that and clic

Re: $$Excel-Macros$$ FOR MIS

HI Aftab, U can use filters. On 8/11/10, Mukesh Kukreja wrote: > > > i hope it will resolve ur problem, if not pl let me knw what exactly u want > > > > On Wed, Aug 11, 2010 at 12:50 PM, ALAM wrote: > >> DEAR ALL, >> >> I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED. >> >>

Re: $$Excel-Macros$$ FOR MIS

i hope it will resolve ur problem, if not pl let me knw what exactly u want On Wed, Aug 11, 2010 at 12:50 PM, ALAM wrote: > DEAR ALL, > > I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED. > > REG > > I WANT TO DETAILS ACCORDING TO EMP-ID, JUST FOR S

$$Excel-Macros$$ Splitting cell contents into multple rows

Hello, Attached sheet contains data in column A where data in each cell is separated by ( | ). I want to separate out the data into multiple rows without overwriting. For example: Column A contains the data Row1:US20100081275A1 Row 2: CN101682937A_ | JP2010506381A_ | KR2009071614A_ | US2008008

$$Excel-Macros$$ FOR MIS

DEAR ALL, I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED. REG I WANT TO DETAILS ACCORDING TO EMP-ID, JUST FOR SELECTED IMP-ID PLS FIND AN ENCLOSED FILES -- Regards&Thanks, AFTAB ALI 9310903589 -- ---

Re: $$Excel-Macros$$ Pivot table problem

Thanx!! Flemos On Sat, Aug 7, 2010 at 2:50 PM, Deepak Rawat wrote: > Hi all > > I have attached a file containg pivot table with some data. > I have two qurries > 1. I want to put a foruma next to pivot table and want to copy and paste > all formula to all rows but its taking freezing cells by

$$Excel-Macros$$ Re: Bring in all matched unique values using lookup

I guess these are in ColA and ColB. In ColC =CONCATENATE(A1,B1), then sort, then filter unique values. Or the counties are all different? If so sort the counties only, combined and find unique values. If the above not work, then code. let me know. David On Aug 9, 1:06 pm, daruM wrote: > Hello,

Re: $$Excel-Macros$$ Assistance Required

Thanks dude. It works. Best Regards, PRATHAP D M +91 9899-370-328 On 9 August 2010 19:26, Bruno Bruno wrote: > My friend Prathap, > > Yes, there is. I did it in the Sample I am returning to you, but I would > strongly recommend other simpler ways to do it. > > The point is that up to Excel-0

$$Excel-Macros$$ Re: Fwd: CAN HTML file Connect to Excel file

Hi Rajesh We can import the data from the web, "Click on Data Tab --> From Web" (in office 2007) Regards Rajender Soni On Aug 10, 8:17 pm, Rajesh Nair wrote: > -- Forwarded message -- > From: Rajesh Nair > Date: Fri, Aug 6, 2010 at 1:27 PM > Subject: CAN HTML file Connect to E

$$Excel-Macros$$ Re: Bring in all matched unique values using lookup

Hi Please find attached the solution. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.