Auto apply date to copied rows

Question

I have data in one spreadsheet that is then copied into a "dashboard" spreadsheet, but would like a date to be attached automatically to each line in column BH. The data comes in from a macro. The column range will not change but the row volume will. Is there any way to do this through the Macro? See attached.

Thank you!

shetzel · Answer

This is the attached.&nbsp;shetzel&nbsp;

hansvogelaar · Answer

shetzel&nbsp;
Do you already have a macro? The workbook is .xlsx so it does not contain macros.

shetzel · Answer

I have the macro enables sheet which I will attach and I will also attach the sheet where I would like the data to go to. I tried to copy my steps and record the macro but it stops part way through. Please let me know if the speadsheets attached or not. Thank you

shetzel · Answer

Here are the attachments.shetzel&nbsp;

hansvogelaar · Answer

shetzel&nbsp;
Thanks. Your macro contains the lines
    Windows("8.19.24 Priorities-Hours Due by Machine.xlsx").Activate
    Sheets("Dispatch Data").Select
    Range("A2").Select
    ActiveSheet.Paste
Insert the following line below it:
    Range("BH2:BH" &amp; Range("A" &amp; Rows.Count).End(xlUp).Row).Value = Date

Forum Discussion

Auto apply date to copied rows

7 Replies

Resources