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 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?
1 Reply
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.
