1
vote
3answers
11k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
0
votes
0answers
401 views

Using VBA how can I reassemble Excel worksheets in different workbooks while maintaing the format?

I am struggling to complete this code successfully. Basically I have a master workbook which has defined range names. The first range is the header followed by a number of ranges (section1, section2. ...
2
votes
1answer
185 views

Merging Excel files on a keyfield

Using the answer to this question as my starting point, I have a slightly different scenario that I'm stuck on. Consider: File 1: Incident# (key), foo1, foo2, foo3 File 2: Incident# (key), status, ...
1
vote
2answers
152 views

Formula to merge column from sheetA to sheetB to matching ID

Match unique id Sheet1!A2 to a cell in Sheet2!A2:A100 that has the matching ID. Paste cell content from column Sheet2!C2:C100 from the same row with the matching id in Sheet2 to the cell with formula ...
1
vote
2answers
986 views

Merge two Excel sheets

I have two 'tabs' in my Excel file and I would like to merge the two tabs into one sheet (in the same file). The two files look somthing like: artnr language description price artnr ...
0
votes
2answers
572 views

excel - merge cells including a zip code

I have the need to merge a bunch of cells that comprise an address (street, city, state, zip) into a single cell. No problem except with the zip code. The zip cell has only 4 digits for any zip ...