If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditionally linking to different cells
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! |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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! "Dave O" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking buttons to cells | Stuart | Worksheet Functions | 7 | September 8th, 2004 02:11 PM |
Linking excel cells to Access Fields | chiligoldva | Worksheet Functions | 2 | February 13th, 2004 09:57 PM |
Linking cells in a workbook | Jim | Worksheet Functions | 0 | December 2nd, 2003 01:08 PM |
Linking cells in a workbook | aet-inc | Worksheet Functions | 0 | December 2nd, 2003 01:37 AM |