Hi all,
I am an absolute beginner in VBA, I desperately need a solution for my problem at work.
I have multiple workbooks that generate a sheet named "extraction Data" which is the 11th sheet in the workbook, with cell references A1-X5. Now these workbooks are completed on a daily basis and are saved with the filename format "ROV dd mmm yyyy" e.g. ROV 07 Oct 2013. These files are then stored in a week commencing folder, e.g. WC 07 Sep 2013. These folders are then stored in a month folder, e.g. October 2013. These folders are then stored in a Title Folder, e.g. ROV. This is the complete structure. I then have multiple title folders with the names of L03, L05, L06, L08, Rov, L7a - all containing the same structures, down the the filename headers.
What I would like to do, is make a 'master sheet' which copies the 'extraction data' sheets from these workbooks and pastes them in a list on a single sheet. I am unsure of the best, easiest, and most thorough way of doing this and would like input and help of anybody willing. Your thanks in advance.
I am more than happy to send examples and files over to an email, but cannot really post here because of confidentiality reasons.
Please Help me!
Bookmarks