Hi,
I am hoping you all can help me - I have had a lot of success asking you guys and girls in the past!
I am looking to link several (more than 70) spreadsheets to one master spreadsheet.
I have created an 'electronic timesheet' that will be distributed to over 70 members of staff. On the spreadsheet is a save button that I have created which will save their timesheet with a name based on cells in the workbook and in a folder based on cells in the workbook.
I now wish to create a master spreadsheet which will collate some of the data in these 70+ spreadsheets.
What is the easiest way to do this? Is it possible for me to edit my 'save' button so that when pressed it sends data to the 'master' spreadsheet? This would have to look at some of the data in the master spreadsheet and put it in the correct place.
All of the 70+ spreadsheets will be password protected with an end user created password although they will all have a master password for read only access.
Any help would be really appreciated!
Thanks in advance
Andy