W
Weasel
I'm working on a workbook with two sheets. One sheet has all my monthl
data (actuals) in it broken up by each day and the other sheet (mai
flash) pulls data from the actuals sheet. What I want to do is:
1. Enter a date in the main flash sheet
2. Based on that date I need cell B5 to equal data from the actual
sheet that has the same date.
For example: In the actuals sheet I have 3/24/06 listed in cell B2
(with dates above and below in order). In cell C22 I have a value o
500. When I go to the main flash sheet and enter 3/24/06 into Cell A1
want Cell B5 in the main flash sheet to equal 500. If I enter 3/25/0
I'd want it to look in cell C23 and so on.
Thanks in advance for any hel
data (actuals) in it broken up by each day and the other sheet (mai
flash) pulls data from the actuals sheet. What I want to do is:
1. Enter a date in the main flash sheet
2. Based on that date I need cell B5 to equal data from the actual
sheet that has the same date.
For example: In the actuals sheet I have 3/24/06 listed in cell B2
(with dates above and below in order). In cell C22 I have a value o
500. When I go to the main flash sheet and enter 3/24/06 into Cell A1
want Cell B5 in the main flash sheet to equal 500. If I enter 3/25/0
I'd want it to look in cell C23 and so on.
Thanks in advance for any hel