Re: $$Excel-Macros$$ Autofill Macro

2014-05-10 Thread 'karunanithi ramaswamy' via MS EXCEL AND VBA MACROS
 Hello, what is to be autofill. can u give what is in a1 to a5 and what is to be autofilled in b1 to b5 -r.karunanithi. On Saturday, May 10, 2014 6:20 AM, Bill Q ronsmith...@gmail.com wrote: I have spent the better part of 40 minutes searching the web for what I believe is a simple solution.

Re: $$Excel-Macros$$ Autofill Macro

2014-05-10 Thread Vaibhav Joshi
Hi See attachment.. It check if rows in col A is empty or not depending upon it puts value in respective rows of col. B ,C etc... If combination of row col is empty no data will be filled. It takes care upto last Row col. HTH//Cheers On Sat, May 10, 2014 at 6:20 AM, Bill Q

Re: $$Excel-Macros$$ Autofill Macro

2014-05-10 Thread Ashish Bhalara
See the attachment of your solution. Use this function... =IF(A2=,,CONCATENATE(COLUMN(),,,ROW())) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Sat, May 10, 2014 at 1:59 PM, Vaibhav Joshi

$$Excel-Macros$$ Autofill Macro

2014-05-09 Thread Bill Q
I have spent the better part of 40 minutes searching the web for what I believe is a simple solution. I have found many answers. I have tried them all - None are working to what I am looking for. Simply put. - Assume source Data is always is column A. It could be 50 rows in length or 84,679