Is it Possible?? Please help

[Stormseed]

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

 

[patrickmuldoon99]

If you conduct a search, this question has been answered hundreds if not thousands of times on this board.

 

[Stormseed]

mate...would have appreciated even more if u cud have posted the resolution instead of notifying me that the resolution has been posted a thousand times...anyway I am @ fault and my apologies are extended.

 

[Peter_SSs]

Stormseed

See if either of these point you in the direction you want.

http://www.mrexcel.com/board2/viewtopic.php?t=234160

http://www.mrexcel.com/board2/viewtopic.php?t=233921

 

[patrickmuldoon99]

mate...would have appreciated even more if u cud have posted the resolution instead of notifying me that the resolution has been posted a thousand times...anyway I am @ fault and my apologies are extended.

If you look towards the top right of the screen, there is a little button called 'Search' - very useful little gizmo, it allows you to search on keywords against all of the posts on this forum. Of course, you can always wait for someone to do the search for you.

in fact - here's the only link i'm going to give you:

http://www.mrexcel.com/board2/viewtopic.php?t=131687

 

[Stormseed]

Peter -- thanks mate...I do appreciate that...no jokes...please let me know if I can be of any help to you...!