Forum Discussion
Copy Data to Other Sheets' Columns Based on Criteria
I have a SS that is sent to a client every Monday by 7am. They use it to combine with others working on the project and create a report and then send the SS back to us by Wednesday. After receiving...
It would help if you could include redacted/anonymised copies of the workbooks you send and get back.
You could try recording a macro while you do your update and then editing the code to take changing filenames etc. into account.