To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

**Sharonjit** · 12-03-2018, 11:10 AM

Hi Guys,
How can i remove the Grand total value in "DASHBOARD" sheet when i hit a macro?
Is there anything missing?
Please let me know.
Thank you.

Module.PNG

PivotTable.PNG

DashboardNew.PNG

**Logit** · 12-03-2018, 12:32 PM

.
Post workbook.

**Sharonjit** · 12-03-2018, 12:39 PM

Hi Logit,
What do you mean?
You want me to add an attachment?

**PCI** · 12-03-2018, 12:46 PM

Change

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**Sharonjit** · 12-03-2018, 12:54 PM

Hi PCI,
It works perfectly.
Thank you so much for your help.

**PCI** · 12-03-2018, 01:01 PM

You are welcome

To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

LinkBack

Thread Tools

Rate This Thread

Display

To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

Re: To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

Re: To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

Re: To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

Re: To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

Re: To remove Grand total value in "DASHBOARD" sheet at the last row of Column A & B

Thread Information

Users Browsing this Thread

Similar Threads

Go to "Grand Total"

VBA to copy Pivot Table "Grand Total" column

Remove data form one sheet and paste in another sheet (If Column J <> "")

[SOLVED] Pivot Table won't calculate the grand total of "% of income"

Deleting duplicate with "ONE" grand total

How to add a "percentage of grand total" column to pivot table w/o changing all values to%

[SOLVED] Edit the code so that it loops through all worksheets and deletes column with "grand" text

Bookmarks

Bookmarks

Posting Permissions