Is it Possible?? Please help

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 :)
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
If you conduct a search, this question has been answered hundreds if not thousands of times on this board.
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
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.
 

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
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

Banned
Joined
Sep 18, 2006
Messages
3,274
Peter -- thanks mate...I do appreciate that...no jokes...please let me know if I can be of any help to you...!
 

Forum statistics

Threads
1,136,588
Messages
5,676,675
Members
419,643
Latest member
ishanalikhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top