Hi Jerry,
I thought i'd finally managed to create what i was after using a macro i found. However, i've found that the macro i have used only gathers filtered data - i need it to capture all data from the various workbooks' sheet.
To explain further, if 'Sarah' filters data on her spreadsheet (for her personal reference; the invidual spreadsheets are used a lot on a day-to-day basis), when i run my 'master' macro it will only gather what she has filtered at that time. My master spreadsheet therefore will miss data.
Is there a way to amend the macro so that it captures all data, no matter what filters are on/off in the spreadsheets:
Many thanks!
Bookmarks