Forum Discussion
Auto apply date to copied rows
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 co...
Do you already have a macro? The workbook is .xlsx so it does not contain macros.
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
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.PasteInsert the following line below it:
Range("BH2:BH" & Range("A" & Rows.Count).End(xlUp).Row).Value = DateHans,
I keep getting this error when running the macro, do you know what could be causing this? Any help would be appreciated. I inserted in the line from your response below. Thank you