Cost Sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

oibobadilla@gmail.com - 29 Jan 2008 20:04 GMT

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?

Reply to this Message

Max - 29 Jan 2008 23:41 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 5 lines]
> My question is how do I make the information change on the "summary
> page", once you select a different date?

Reply to this Message

oibobadilla@gmail.com - 30 Jan 2008 16:09 GMT

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

-Omar

Reply to this Message

Max - 30 Jan 2008 16:27 GMT

welcome, Omar.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message