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 wa...
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.