Thread: [Solved] Need Help Creating a Macro
View Single Post
 
Old 09-18-2019, 04:59 AM
rsrasc rsrasc is offline Windows 10 Office 2013
Competent Performer
 
Join Date: Mar 2014
Location: Germany
Posts: 148
rsrasc is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Sample Macro.xlsx (48.5 KB, 12 views)
Reply With Quote