1

We are moving to a new payroll system and are trying to move employee data to the new program. Right now, I have three Excel spreadsheets. Each spreadsheet has Employee SSN, First Name and Last Name in separate columns. One spreadsheet has employee address information, another one has hire and wage information. I want to combine the spreadsheets into one master employee spreadsheet. I have yet found a way to combine those spreadsheets.

10 Spice ups
2

Use Vlookup or Match to create a master table then save it once all consolidated

2 Spice ups
3

You can reference other spreadsheets in an open spreadsheet. Or just copy/import the data into separate workbooks.

4

yep, Vlookup or Match, probably vlookup in this instance. just make sure you have some sort of key information that matches across the sheets and also make sure your ending (optional) argument is set for exact match, otherwise you might not like the results.

5

+1 for vlookup. You got Employee SSN on each spreadsheets you can use that as the lookup value to get everything into a single worksheet.

6

SCRIPT IT! Here’s a script that merges excel documents from bottom-to-top (if that makes sense) so maybe there’s a way to do it side by side, like the way you are describing:

$a = get-date
$a.tostring(“MM dd”)
$month = $a.Month
$day = $a.day
get-childItem “*.csv” | foreach {[System.IO.File]::AppendAllText(“C:\Users\Me\Desktop\Squash\NewFileName (” + $month + “-” + $day + “).csv”, [System.IO.File]::ReadAllText($_.FullName))}

Takes all the .csvs in the file ‘Squash’ and turns them into one spreadsheet, it also renames the file to today’s date, but that’s just something else I needed at the time.