grandtotal

  1. K

    Macro for analysing complete block designs

    Hi I am new to excel vba and i am learning on my own to write vba in excel. I have some queries in vba. I created data sheet matrix by entering number of treatments and blocks using vba and entered data into matrix. After i calculated row total and column total using sum function and finding...
  2. B

    Add Worksheets if Does Not Exist

    Have been searching How to add worksheets if does not exist and then add totals to Column B. Not sure How to execute the top portion of the code. thank you Sub TotalEachWorksheet() Grandtotal = 0 Worksheets.Add ActiveSheet.Name = "Summary" Worksheets.Add ActiveSheet.Name =...
  3. A

    Forecasting with PoverPivot (Grand total not ending up correctly)

    Hi there, I'm trying to make a simple forecast for the rest of the year. I have Jan to Jun actuals as monthly values and would like to forecast the rest of the year Jul - Dec, as of Jun actuals for example. Therefore I'm using a disconnected table, where I would select 06 as a parameter for Jun...
  4. B

    Pivot Table Help - Grand Totals

    Hello, Please can someone help me with a question regarding Pivot Tables and GrandTotals. For example I have the data below I am using in my Pivot Table: Name Amount Amount USD Value Jim £100.00 $150.00 Rob £200.00 $250.00 Dave...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top