Recent content by patriciaanne

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

Thanks Skip.. I've been avoiding learning macros but I guess it is time. To everything there is a season, a time for every purpose under the sun.

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