Main file = New data, I would like to add row "42" and change row "53" "P13QR01-2201" to OLD file of row 52 "P13QR01-0800".
Folder:
C:\Users\User\Desktop\Macro VBA
Because I have a variety of file names and a different number of worksheets, it would be even better if I could disregard all of the file names and simply alter all of the different workbooks and worksheets in the folder.
Is this possible to be done with multiple workbooks and every worksheets? I hope the pictures below illustrate my need…Thanks!
Old file data:
New "Main", the file data that I would like to copy to Old files:
Folder:
Folder:
C:\Users\User\Desktop\Macro VBA
Because I have a variety of file names and a different number of worksheets, it would be even better if I could disregard all of the file names and simply alter all of the different workbooks and worksheets in the folder.
Is this possible to be done with multiple workbooks and every worksheets? I hope the pictures below illustrate my need…Thanks!
Old file data:
New "Main", the file data that I would like to copy to Old files:
Folder: