conditionally linking to different cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Conditional formatting of date-cell - 2007 5
Conditional formatting--different formatting depending on cell con 3
... I would like to link conditional formating to linked workbooks 2
Excel Macro to automatically go to the right of the last colored cell 0
Either cell but not both 5
Conditional formatting 1
Conditional Formating based on Date 5

Back
Top