Hello, I would like to ask for a help creating a VBA macro that will automatically copy the whole row when value is entered into a certain cell.
I am on Windows 10, Excel 365 version.
Here is what I am working with, when a date (the script could check for any value but a date will be entered here) is entered in column C and cell C3 onward in sheet 2 (2022) I need the row to be copied over to sheet 1 (Pece):
I tried to copy and edit various macros I found online but I failed to make any of them work.
Thanks in advance!
I am on Windows 10, Excel 365 version.
Here is what I am working with, when a date (the script could check for any value but a date will be entered here) is entered in column C and cell C3 onward in sheet 2 (2022) I need the row to be copied over to sheet 1 (Pece):
I tried to copy and edit various macros I found online but I failed to make any of them work.
Thanks in advance!