Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup to join three + worksheets?
I have a workbook w/three different worksheets. They all contain a column
that has employee IDs each with the same heading. So the columns match, they just contain different #s. I want to pull the ID #s from all three worksheets into a fourth "master" worksheet that will update when new numbers are added to the sheets. (EX: Sheet1- employees who attended training in Boston, Sheet2 = New York, Sheet3 = London. I want Sheet 4 = list all ID#s from all of the cities. When I add new ID#s to Sheet 1, 2, or 3, Sheet 4 will update to reflect the new ID#s). Is that possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup to join three + worksheets?
You're approaching this from the wrong end. Put all the data in a single
sheet, then use Pivot tables or data filters to isolate the New York, Boston, or London data. You'll find this is much more flexible and MUCH easier to maintain. "Aekta" wrote: I have a workbook w/three different worksheets. They all contain a column that has employee IDs each with the same heading. So the columns match, they just contain different #s. I want to pull the ID #s from all three worksheets into a fourth "master" worksheet that will update when new numbers are added to the sheets. (EX: Sheet1- employees who attended training in Boston, Sheet2 = New York, Sheet3 = London. I want Sheet 4 = list all ID#s from all of the cities. When I add new ID#s to Sheet 1, 2, or 3, Sheet 4 will update to reflect the new ID#s). Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I join or merge worksheets in Excel | Excel Discussion (Misc queries) | |||
join rows? | New Users to Excel | |||
join cells for a vlookup | Excel Worksheet Functions | |||
Vlookup in different worksheets | Excel Worksheet Functions | |||
Using vlookup on two worksheets | Excel Worksheet Functions |