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!

Attached Files

Sample Macro.xlsx (48.5 KB, 14 views)