Thanks but I figured another way although it is not totally automated. Macro searches for Grand Total, then macro has an input box that asks number of salespeople (it varies by dept sheet) and it divides that by the pivot grand total.
It works and I am done...Yeah
To everything there is a...
Skip, What you said is true but it creates a column of averages.
All I want is a Grand Total and a Grand Average at the bottom of the pivot table.. summing and averaging the columns.
To everything there is a season, a time for every purpose under the sun.
it did what I thought it would..since it is not in the pivot table, it didn't take it over.... The pivot table lets you summarize by total or average but apparently it only accepts one or the other not both... guess I'll see if it works as a calculated field maybe...
To everything there is a...
can you have both a grandtotal and a grand average on the main pivot table so that when I split the pivot table by salesperson in the report filter both the grandtotal and grand average would both show up on each sheet?
To everything there is a season, a time for every purpose under the sun.
I am way over my head on this part.
Every month I am creating a pivot table and then splitting it into sheets by the report filter. So, the rows and columns on every sheet change every month. The last row of each table and sheet, says Grand Total so my macro is searching for Grand Total and then...
Sorry... I wrote the macros for another person so the personal workbook won't work. Ok.. I'll copy and paste- thanks.
To everything there is a season, a time for every purpose under the sun.
Hi There- Anyone know an easy way to move macros from one workbook to another without first creating a new macro name and then copying and pasting each one in?
Thanks for your help.
To everything there is a season, a time for every purpose under the sun.
Thanks for the suggestions and I think the easiest is to try to keep the same name since I am a novice at VBA.
This is Excel 2007- I don't think there is a pivot wizard anymore. This version lets you add as many new source files as you want but apparently it assumes that you just select the one...
Hi- I have a pivot table that is linked to another Excel spreadsheet in a separate file and the name of that file changes every month (only 1 sheet in the file). I have gone into Workbook Connections and removed the old workbook connection and added the new one and clicked Refresh and it gives...
Hi- I have one big pivot table that has a report/page filter by salesperson and then that pivot table is broken down into 15 subsidiary pivot tables by salesperson. Each month I want to mail each salesperson their detail but I do not want them to be able to see each others.
I tried going to...
Thanks Skip... sorry I misunderstood what you said.. that should work... thanks
To everything there is a season, a time for every purpose under the sun.
Thanks but Skip this spreadsheet is used by a number of people so the protection has to stay on.
And yes, there is adjacent data in the next column that is locked. So, why on earth would Excel allow you to sort a protected spreadsheet if all the columns have to be unprotected first?
To...
To create a running total...
Assume your amount starts in A2 and runs down the column.
To create the running total in Column B, in B2, type =sum(A$2:a2) and copy it down.
To everything there is a season, a time for every purpose under the sun.
Hi
I am trying to sort a protected Excel worksheet. I unlocked the cells in the column I want to sort and then protected the worksheet. I selected "Select unlocked cells" and then selected "sort" before protecting the rest of the worksheet.
I can change the numbers in the unlocked column but it...
Glen- Thanks-you are correct however I still can't figure out how to to customize the look of Outlook Today ie. Change how many appointments appeared, change the layout and sort the task list etc. Any idea how to do that now? Outlook 2002 had a button on the Outlook Today toolbar that said...
I must be losing it. In Outlook 2002 I had no problem but how do you customize the Outlook Today page in the 2003 version?
Help says to
1. On the Go menu, click Shortcuts.
2. In the Navigation Pane click Outlook Today.
3. On the Outlook Today page, click Customize Outlook Today
When I click...
Hi- I exported my Outlook Contact list to Excel and filtered it. I saved the new file. When I use the Mail Merge Wizard in Word, it allows me to select the excel file as the recepient file but then displays a dialog box showing three different Contact tables. No matter which I select, I always...
In Excel 2002, you can easily convert text to numbers
Convert numbers stored as text to numbers. see how below. If you are using an earlier version of Excel, you may have to use =1*value(cell reference) to convert it to a numbers.
See Excel 2002 Help menu on converting text to numbers.
On the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.