Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2015, 05:06 PM
shilabrow shilabrow is offline Column Merge - All help appreciated Windows Vista Column Merge - All help appreciated Office 2007
Advanced Beginner
Column Merge - All help appreciated
 
Join Date: Apr 2014
Posts: 45
shilabrow is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-07-2015, 10:59 PM
excelledsoftware excelledsoftware is offline Column Merge - All help appreciated Windows 7 64bit Column Merge - All help appreciated Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Merge - All help appreciated 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
Column Merge - All help appreciated mail merge using data from column A as placeholder. keys Mail Merge 2 10-31-2013 01:55 AM
Column Merge - All help appreciated 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 02:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft