FFNStaff
asked on
Excel 2010 - Is there a way to put personalized information into a header of a spreadsheet?
Hi,
I have a spreadsheet with data for about 100 sales people. There are from 2-8 rows for each person. I will eventually subtotal and print each person's information on sheets with just their information.
At the top of the sheet, in the header or not--whichever works, I would like to add a cell referencing their total production which is on another tab in the workbook. Is there a way to do this?
I've tried a vlookup, but that doesn't change from sheet to sheet.
Suggestions?
Book2.xlsx
I have a spreadsheet with data for about 100 sales people. There are from 2-8 rows for each person. I will eventually subtotal and print each person's information on sheets with just their information.
At the top of the sheet, in the header or not--whichever works, I would like to add a cell referencing their total production which is on another tab in the workbook. Is there a way to do this?
I've tried a vlookup, but that doesn't change from sheet to sheet.
Suggestions?
Book2.xlsx
ASKER
I trying to have 1 sheet per salesperson. The lifetime production cell would have the total for the person on that sheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, Glenn.
Are you trying to have a dropdown / pick the name/ display the summary?
or, are you trying to have 1 sheet per each salesperson?