| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change the reference in a formula based on a logic test?
I need the formula to change the name of the source file based on a logic
test. For examle, how would I change the following so that it references a different file name based on the day of the month? ='C:\[MTG Source File 1.xls]Sheet1'!$A$1 I know how to get the day of the month, just haven't been able to get the name of the file to change in the formula without a reference error. Thanks so much in advance, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the color of a cell in a logic formula | Excel Discussion (Misc queries) | |||
| reference, test and change cell font. | Excel Programming | |||
| logic test | New Users to Excel | |||
| change text color based on logical test | Excel Worksheet Functions | |||
| Logic test | Excel Programming | |||
Threaded Mode
