I would like to make code or to open multiple excel sheets copy a specific cells from it and then paste all that info in a specific workbook.
I have a folder with a group of folder which are organized by day
Folder
Folder 01-01-2008
B1.zip
B2.zip
Folder 02-01-2008
B1.zip
B2.zip
…
Folder 01-12-2008
Folder 02-12-2008
And so on.
Inside each folder there are two zip files b1.zip and b2.zip
That zip files are excel file.
Ok, I would like to open the b1 zip file and b2 zip file for each in specific month let say January which will be the entire folder with Folder xx-01-xxxx
Extract a data from all that excel sheets and paste to another workbook.
Do you thing that is possible to do?
Bookmarks