| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match first and last name and insert column into existing sheet
I have two sheets, Sheet1 and Sheet 2
In Sheet1 and Sheet2 Last name and first name are in column A and B (respectivly) However, Sheet2 is a pivot table. I need to insert column I and J of Sheet2 into Sheet1 if the first and last name matches exactly. I am having issues with the funtion, and do not know if I need to do something differently because it is a pivot table |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match first and last name and insert column into existing sheet
Use the GetPivotData function. See he
http://www.contextures.com/xlPivot06.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Sarah" wrote: I have two sheets, Sheet1 and Sheet 2 In Sheet1 and Sheet2 Last name and first name are in column A and B (respectivly) However, Sheet2 is a pivot table. I need to insert column I and J of Sheet2 into Sheet1 if the first and last name matches exactly. I am having issues with the funtion, and do not know if I need to do something differently because it is a pivot table |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert a colon into a column of existing numbers | Excel Discussion (Misc queries) | |||
| How do I insert sub-columns within an existing column? | Excel Discussion (Misc queries) | |||
| How do I insert template in new sheet of pre-existing excel file? | Excel Worksheet Functions | |||
| How do I insert a new work sheet into an existing workbook? | Excel Discussion (Misc queries) | |||
| How do I insert a header on an existing Excel sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
