Stormseed
Banned
- Joined
- Sep 18, 2006
- Messages
- 3,274
ASSUME...
I have 6 different workbooks - each workbook have a worksheet - is there a way thru VBA - where it does copy all the different worksheets in different workbooks into one single workbook?
MVPs -- I need your expert comments on this please ! Kindly let me know if there is a way or do I have to do it manually.
thanking you in anticipation![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have 6 different workbooks - each workbook have a worksheet - is there a way thru VBA - where it does copy all the different worksheets in different workbooks into one single workbook?
MVPs -- I need your expert comments on this please ! Kindly let me know if there is a way or do I have to do it manually.
thanking you in anticipation