Forum Discussion
Automatically updating an excel spreadsheet when source spreadsheet cells change
I am trying to design a "program" where information is captured on one large excel sheet and different secondary sheets are then updated from the main source sheet. Say sheet 2 is a file cover, I want to copy row 2 cells onto the file cover in their respective locations. Tomorrow I will need to do the same for row 3 on the source sheet. How do I do this?
- Have a look at Data, Get Data, From File, From Workbook. You can set these up so they refresh when you open the file and even every minute or so.
Thank you I will try that, JKPieterse.
