Column Merge - All help appreciated

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:12 AM.