Hi

Try this to copy the sheet from each workbook into the master workbook
http://www.rondebruin.nl/copy3.htm

Use
http://www.rondebruin.nl/copy3.htm#sheet



--
Regards Ron de Bruin
http://www.rondebruin.nl


"sowetoddid " wrote in message ...
I have a Master file containing 15 different tabs. The tabs are labeled
"Georgia", "Ohio", "Texas", etc.

The data on each tab needs to be completed by a different person. To
make viewing easier for each person, I generated a single file (e.g.
"Georgia" file, "Ohio" file, etc.) to send each person. After they
complete their particular file, it is sent to me and saved into a
folder labeled "states".

Is there a VB code for the Master file that will automatically copy the
values from each file ("Georgia", "Ohio", etc.) and paste them to the
appropriate tab in the "states" file.

Cells C1:X50 need copied and pasted.


Thanks you!


---
Message posted from http://www.ExcelForum.com/