Cost Sheet
 

I'm trying to come up with a daily cost sheet. What I've done so far
is develop a tab on the spreadsheet that has all the information, that
I want to retrieve. Now, what I want to do is develop a "summary
page" that retrieves information by date. So, what I did was come up
with a drop down menu where you are allowed to select the date on
which you want to view the performance of the day.

My question is how do I make the information change on the "summary
page", once you select a different date?

Cost Sheet
 

One way is illustrated in this sample:
http://www.freefilehosting.net/download/3b72d
Viewing data by selectable date.xls

Source data assumed in Base

In View,
With a DV to select date in B3

In D3:
=IF($B$3="","",OFFSET(INDIRECT("'Base'!A"&MATCH($B $3,Base!$A:$A,0)),ROWS($1:1),COLUMNS($C:C)-1))
Copy D3 across/fill down to E6 to populate (same size as the data range per
date in Base) Adapt to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
I'm trying to come up with a daily cost sheet. What I've done so far
is develop a tab on the spreadsheet that has all the information, that
I want to retrieve. Now, what I want to do is develop a "summary
page" that retrieves information by date. So, what I did was come up
with a drop down menu where you are allowed to select the date on
which you want to view the performance of the day.

My question is how do I make the information change on the "summary
page", once you select a different date?

Cost Sheet
 

Max, you are awesome. This is exactly what I was looking for; you've
made my day!

-Omar

Cost Sheet
 

welcome, Omar.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
Max, you are awesome. This is exactly what I was looking for; you've
made my day!

-Omar