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 |
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 |
All times are GMT +1. The time now is 12:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com