#1
|
|||
|
|||
Column Merge - All help appreciated
I have 12 folders each with 2 or more worksheet with similar records in them. I want to automatically merge Column E, F, G, H together into one Worksheet as one file (i.e. From all worksheet in all separate folder into ONE Worksheet under heading E, F, G, H).
Also I want to create another Column D and Put the file name that corresponds to each data row So I can quickly tell which worksheet the data is from. Any help will be appreciated. Thanks Much. |
#2
|
|||
|
|||
I need to clarify some things. When you say 12 folders do you mean you have 12 folders on your computer with 2 or more WORKBOOKS in them that you want to merge into 1 worksheet? Or do you have 12 Workbooks with 2 worksheets each that you want to merge into 1 worksheet.
Both are possible and just require some amount of code to do it. If it is folders then I will need the address of where all the folders are in and if there are multiple files in those folders that are not Excel books I will need the Excel book names. Just so you know this will most likely be a long process to get you a code that works since all of the needed information to get it right the first time is on YOUR computer. I am happy to help no matter what but I just want you to be prepared for that. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge From Excel With Table in Word - Next Record If Excel Column Same? | misscrf | Mail Merge | 2 | 10-15-2014 11:51 PM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
mail merge using data from column A as placeholder. | keys | Mail Merge | 2 | 10-31-2013 01:55 AM |
Page breaks....Ctrl-Enter..help is appreciated | typing33 | Word | 2 | 02-10-2013 02:19 PM |
Mail Merge Anchoring column layouts | HWSpencer | Mail Merge | 0 | 04-25-2008 06:08 AM |