contactm77
New Member
- Joined
- Aug 9, 2010
- Messages
- 6
I want to merge files of same name stored in different folders .All folders are stored at common directory path for e.g. C:/my documents/data. This then has all subfolders which contain excel sheets of same name. For e.g. extract.xls stored in folder 1, folder 2, folder 3.
Structure of extract.xls file is: each file has same five tabs (worksheets- named tab1, tab2, tab3., tab4, tab5). Each tab has data spread between columns A until CZ (which is max column name). The data stored within each tab varies - so number of rows would change for each tab under each file. The actual data starts from row 7 in all tabs but cells A1 until C3 has some information which is not required to be copied in master file.
I need to copy data stored in one tab (e.g. tab1) of one file (extract.xls under folder 1) into a master file (which is stored at common path) which will have same tab name. Underneath this data I need to copy data from tab1 for second file (extract.xls stored at folder 2). I need to do something but not aware of VB macros.
Please can you help?
Thanks,
MK
Structure of extract.xls file is: each file has same five tabs (worksheets- named tab1, tab2, tab3., tab4, tab5). Each tab has data spread between columns A until CZ (which is max column name). The data stored within each tab varies - so number of rows would change for each tab under each file. The actual data starts from row 7 in all tabs but cells A1 until C3 has some information which is not required to be copied in master file.
I need to copy data stored in one tab (e.g. tab1) of one file (extract.xls under folder 1) into a master file (which is stored at common path) which will have same tab name. Underneath this data I need to copy data from tab1 for second file (extract.xls stored at folder 2). I need to do something but not aware of VB macros.
Please can you help?
Thanks,
MK