Re: $$Excel-Macros$$ Extracting address from a file

2011-03-10 Thread CAN
I couldn't upload the sample file, but today I emailed it to group address. On Mar 10, 4:20 am, Sanjoy Nath wrote: > no sample is there. >    One thing more , for this , we can use the formula like > =indirect(Address(row,column) > > and no things like macro is necessary for all kinds of transfor

Re: $$Excel-Macros$$ Extracting address from a file

2011-03-10 Thread Sanjoy Nath
no sample is there. One thing more , for this , we can use the formula like =indirect(Address(row,column) and no things like macro is necessary for all kinds of transformations On Wed, Mar 9, 2011 at 10:41 PM, CAN wrote: > First of all, thank you for all the help that I received so far.

$$Excel-Macros$$ Extracting address from a file

2011-03-09 Thread CAN
First of all, thank you for all the help that I received so far. You guys are great. Today I have the following problem. I have a file where all the data is on column A. The data is listing the name of a person in row 1, in row 2 and row 3 it list the address. from the sample below I like to