ExcelTheCell
Board Regular
- Joined
- Nov 14, 2010
- Messages
- 158
Hi guy's well i am back and i hope you can help me....
I have 4workboks:
One
Two
Three
Four
And Every of them has two worksheet's with same name:
First
Second
Paths of workbooks:
One.xlsm= "C:\One\"
Two.Xlsm= "C:\Two\"
Three.xlsm= "C:\Three\"
Four.xlsm= "C:\Four\"
Main Book path:
MainBook.xlsm="C:\"
I want to merge only Worksheet "Second" from all workbooks into Mainworkbook that already contains also Worksheet "Second"... Also first Row contains Header..
Please help me 2 weeks and still don't have any good solution by now
I have 4workboks:
One
Two
Three
Four
And Every of them has two worksheet's with same name:
First
Second
Paths of workbooks:
One.xlsm= "C:\One\"
Two.Xlsm= "C:\Two\"
Three.xlsm= "C:\Three\"
Four.xlsm= "C:\Four\"
Main Book path:
MainBook.xlsm="C:\"
I want to merge only Worksheet "Second" from all workbooks into Mainworkbook that already contains also Worksheet "Second"... Also first Row contains Header..
Please help me 2 weeks and still don't have any good solution by now