Filling in a Summary from a dated list

[shawn350]

I have a problem.

I have to report nightly numbers for multipule stores every night.

The Summary needs to have the Sales how many Trans how do
I get this to auto maticly add this to a dated list and update the month to date section.

Or

how do I type info in a list and tell a cell to display a certian dates info i.e. the infor for that night.

Thanks

 

[shawn350]

To clarify

I basicly want to do If (Date in Cell = date in another cell) Put data from Cell X into Cell Y.

That way the Summary page auto populates itself with the data from the


Date Sale Trans
1/1/05 400$ 21
1/2/05 600$ 34


This info needs to automaticly go to a summary that would look


Nightly numbers for 1/2/05

Sales 600 Trans 34


Month to Date

Sales 1000 trans 55

hope that clarifys

 

[KleptoOne]

Send me your email addy and I can send you a sample sheet that you might be able to adapt for your purpose.

 

[shawn350]

shawn.hendrix@games-workshop.com