In Excel, I have created a sheet/form for each sales person with annual totals pulled into a pivot table (a sample of what I am working with is attached). The yellow and blue areas are on each page and green is the data from the pivot table. The green will be personalized for each sales person.
1. In the yellow area, where the XXXXs are, I want to pull the name of the sales person. I tried using a basic =a6 which put the first sales person's name on each of the following sheets too. Is there a way to personalize the sheet name for the person the data is for?
2. Is there a way to put information not included in the pivot table in the white space between the green and blue space? Perhaps using Visual Basic? I want to put some statistical information that would be the same on each sheet but is too cumbersome for the footer. (I've used VB in the past but wouldn't know the text to use.)