0
votes
4answers
72 views

Excel - How to merge rows from 2 tables based on a common column?

I am trying to merge 2 worksheets where only one col matches in content. Column"A" in both worksheets have matching values but all other fields are different. Worksheet1 Col"A" colb colc cold ...
0
votes
2answers
89 views

Create New Spreadsheet of data from many Excel workbooks

In retrospect, this is an issue of data-collection, but I want to see if there is an easy way to do it without doing each file. I have about 350 separate Excel workbooks. Each workbook has a bit of ...
1
vote
3answers
42k 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 ...
2
votes
1answer
236 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
163 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
1k 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
648 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 ...