Sales Pacing Forecasting - Weekly report changing figures

conorrey

New Member
Joined
Sep 27, 2010
Messages
43
Office Version
  1. 365
Platform
  1. Windows
Good Morning,
I have a report that comes out of our system weekly. It shows all past business actual revenues e.g anything before today and all future(today to the end of time!) forecasted revenues. We are trying to look at or pull the data so that it does the below.

*** Put a date in a cell e.g. A1 and A2 and it will input the figures between those two dates on the current report. We then put another date in cell b1 and it will pick up the file from that date and show the same range(A1 and A2) at that time .


I have tried using indirect and index formulas but cannot get it to work. I cannot use copy/paste as we will be in and out of sheets all the time copying and pasting. e.g. one minute we might look at where we were in July last year for the dates in A1 and A2 and then want to look at August.

Any help would be great.

Conor
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,898
Messages
6,175,272
Members
452,628
Latest member
dd2

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