Copy data in multiple sheets and paste into one sheet.

**Slomaro2000** · 11-03-2008, 09:56 AM

I have multiple .xls sheets in a folder

C:\Documents and Settings\u369875\Desktop\Project stuff\Testin Save_AS\Completed History

And need to copy the data in all of them and paste them into a new sheet (one main sheet) in this folder

C:\Documents and Settings\u369875\Desktop\Project stuff\Testin Save_AS\Ready for GEMTS

Also is ther any way to get the main sheet named

Ready for GEMTS

?

**Slomaro2000** · 11-04-2008, 11:50 AM

Here is what I have so far.

I did some searching and found this.. I believe it was posted by Ravishankar (not 100% sure though)

Its working pretty good.

I just changed

Please Login or Register  to view this content.

To this so it would just look in that folder instead of allowing you to choose.

Please Login or Register  to view this content.

Here it is.

Please Login or Register  to view this content.

Now just need this to save automatically to

Please Login or Register  to view this content.

as "Ready for GEMTS"

**ravishankar** · 11-05-2008, 05:27 AM

Hi
These codes were not written by me. If it is working for you, that would be nice
Ravishankar

Copy data in multiple sheets and paste into one sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Copy data in multiple sheets and paste into one sheet.

codes

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions