troubleshooting Question

Excel 2013 Pivot Table Form

Avatar of FFNStaff
FFNStaffFlag for United States of America asked on
Microsoft Excel
11 Comments1 Solution111 ViewsLast Modified:
Hello,

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.  

2 questions:  

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.)

Thank you!

Pat
Sales-Summary.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”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