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.)
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.