Hi Guys,
I have about 800 workbooks saved in a specific folder, each with a different name.
There are two generic formats within these 800 workbooks.
I need to create a macro which will open each of the 800 booklets, then determines which format the booklet contains
and then copy paste special two cells from the booklet to my master sheet.
Basically the two formats have different tab names which i need the data from, the names of the tabs, and the cell contents to copy are:
format 1) Tab Name: Q4 Progress Review ( Copy cells B6 [to Cell A1] and C21 [to B1] )
format 2) Tab Name: Summary Sheet ( Copy cells D5 [to cell A1] and D48 [to cell B1] )
The code will need to open the first booklet in the folder, then
distinguish whether a tab name in the book is named either 1) "Q4 Progress Review" or 2) "Summary Sheet"
If it is named the first point, then it will copy cell B6 from the booklet to cell A1 in master file and cell C21 from booklet to cell B1 in master file..
Then the code will continue to the next booklet and loop (so that the 2nd booklet copies the data into cells A2 and B2 in the master file and so on...)
This has me totally stuck!!
I will be extremely greatful for anyone who can help me out with this.
Thanks in advance!!!
I have about 800 workbooks saved in a specific folder, each with a different name.
There are two generic formats within these 800 workbooks.
I need to create a macro which will open each of the 800 booklets, then determines which format the booklet contains
and then copy paste special two cells from the booklet to my master sheet.
Basically the two formats have different tab names which i need the data from, the names of the tabs, and the cell contents to copy are:
format 1) Tab Name: Q4 Progress Review ( Copy cells B6 [to Cell A1] and C21 [to B1] )
format 2) Tab Name: Summary Sheet ( Copy cells D5 [to cell A1] and D48 [to cell B1] )
The code will need to open the first booklet in the folder, then
distinguish whether a tab name in the book is named either 1) "Q4 Progress Review" or 2) "Summary Sheet"
If it is named the first point, then it will copy cell B6 from the booklet to cell A1 in master file and cell C21 from booklet to cell B1 in master file..
Then the code will continue to the next booklet and loop (so that the 2nd booklet copies the data into cells A2 and B2 in the master file and so on...)
This has me totally stuck!!
I will be extremely greatful for anyone who can help me out with this.
Thanks in advance!!!