Copy Data to Other Sheets' Columns Based on Criteria

[John Stender]

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 the SS on Wednesday it takes considerable time to update it with data from Mon-Wed that has already been done.  Can I import data from last week's SS (after adding my Mon-Wed edits) into the new SS that comes out on Wednesday.  In other words can I import only cells that have certain dates into the new SS?

[#2]

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.