rolling columns

  1. A

    How to sum vertical data with horizontal criteria?

    I'm stumped on how to automatically sum data from a rolling report. The report I'm using is pre-set and only comes back in 1 format, with the criteria I need to use across the top with my sales cascading below. I want this to automatically calculate last week's total sales whenever I put the...
    • alzoell
    • Thread
    • criteria range item rolling columns sum sum a column
    • Replies: 5
    • Forum: Excel Questions
  2. D

    Formula with rolling columns

    Hi Guys! Hope to find you well! I got a problem with a VBA code. here the problem: I get 2 sheets: sheet1 and sheet2. Sheet2 changes every day, fulling in one more column each day that passes. for example Day one there will be 2 column filled with data, day 2, 3 columns and so on. I was...
    • Dan4321
    • Thread
    • formula macro rolling columns rolling data vba
    • Replies: 3
    • Forum: Excel Questions

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