conditionally linking to different cells

R

redb

Hi! I maintain a worksheet that displays yesterday's revenue. I would like
to be able to see any particular day's results just by imputing the date at
the top. Basically, I would like to put the date in cell A1, and in the main
area of the worksheet all of the numbers for that day are pulled. All of the
raw data is located to the far right, so it would just be a matter of
conditionally linking to that information based on what day it is. Is this
possible?

Even if it is not possible using dates, is it possible by any other method?

Thanks!
 
D

Dave O

It is possible, assuming the revenue information has a date cell (or
some other relevant data cell) associated with them. Check out the
SUMIF() formula. If you're still without a solution after that, post
again with a sample layout of your data, and someone will be able to
provide a clever solution, I'm sure.
 
R

redb

Thanks for the help, Dave O. While that wasn't quite what I was looking for,
it did help in another part of my project, so you did help me out.

Thanks!
 
Top