Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto merge files
I have a Master file containing 15 different tabs. The tabs are labele
"Georgia", "Ohio", "Texas", etc. The data on each tab needs to be completed by a different person. T make viewing easier for each person, I generated a single file (e.g "Georgia" file, "Ohio" file, etc.) to send each person. After the complete their particular file, it is sent to me and saved into folder labeled "states". Is there a VB code for the Master file that will automatically copy th values from each file ("Georgia", "Ohio", etc.) and paste them to th appropriate tab in the "states" file. Cells C1:X50 need copied and pasted. Thanks you -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
merge 2 files | Excel Discussion (Misc queries) | |||
Merge 2 Files | Excel Discussion (Misc queries) | |||
how do I merge two files? | Excel Discussion (Misc queries) | |||
MERGE 2 FILES | Excel Discussion (Misc queries) |