Column Merge - All help appreciated

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Column Merge - All help appreciated

FAQ

Thread Tools

Display Modes

01-29-2015, 05:06 PM

shilabrow

Windows Vista Column Merge - All help appreciated

Office 2007

Advanced Beginner

Join Date: Apr 2014

Posts: 45

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:45 PM.