| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
new cell for each day
I am trying to use the date cell in one workbook to determine what cell of
another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
new cell for each day
Pls stay in your ORIGINAL thread. INDIRECT only works with OPEN workbooks. -- Don Guillett Microsoft MVP Excel SalesAid Software "Libby" wrote in message ... I am trying to use the date cell in one workbook to determine what cell of another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
new cell for each day
The workbook is open
-- Libby "Don Guillett" wrote: Pls stay in your ORIGINAL thread. INDIRECT only works with OPEN workbooks. -- Don Guillett Microsoft MVP Excel SalesAid Software "Libby" wrote in message ... I am trying to use the date cell in one workbook to determine what cell of another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
new cell for each day
=indirect("'[Apr MIR.XLS]Mid-City'!g"&$a$44+9))
or maybe... =indirect("'[Apr MIR.XLS]Mid-City'!g"&day($a$44)+9)) (I'm not sure what's in A44.) You don't need the +, either. Libby wrote: I am trying to use the date cell in one workbook to determine what cell of another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
new cell for each day
Cell a44 is the "yester"day of the month. the formula is not returning
anything its just showing the formula in the cell by "Dave Peterson" wrote: =indirect("'[Apr MIR.XLS]Mid-City'!g"&$a$44+9)) or maybe... =indirect("'[Apr MIR.XLS]Mid-City'!g"&day($a$44)+9)) (I'm not sure what's in A44.) You don't need the +, either. Libby wrote: I am trying to use the date cell in one workbook to determine what cell of another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
new cell for each day
Format the cell as General (anything but text).
Then reenter the formula. Libby wrote: Cell a44 is the "yester"day of the month. the formula is not returning anything its just showing the formula in the cell by "Dave Peterson" wrote: =indirect("'[Apr MIR.XLS]Mid-City'!g"&$a$44+9)) or maybe... =indirect("'[Apr MIR.XLS]Mid-City'!g"&day($a$44)+9)) (I'm not sure what's in A44.) You don't need the +, either. Libby wrote: I am trying to use the date cell in one workbook to determine what cell of another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
