Need Help Creating a Macro
Hi all,
I have a file with 26 sheets. On every sheet, I have a date in cell "A4.''
Every sheets has about 450 rows with information. Of course, some rows don't have any info on it.
In column B on every sheet there is some information on it.
I would like to have a macro that will copy the value of cell A4 all the way down in column C assuming there is a value in Column B.
See attached sample file with two tabs-name it "Before" and "After".
If anyone has a question, please let me know so I can clarify it.
Thank you in advance for your support.
Cheers!
|