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