Re: new cell for each day

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
dguillett1@xxxxxxxxxxxxx
"Libby" <Libby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:76C85A46-5B85-4AEF-9BAE-7106AEF6AE39@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Excel should let its worksheets be arranged (tiled) in a workbook
    ... "only open workbooks can be arranged in this way". ... Both worksheets 1 and 2 will be visible. ... Gord Dibben MS Excel MVP ... >worksheets could be arranged within the workbook window. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can excel formulas become frozen?
    ... Probably Calculation is set to Manual ... This is a setting for all open workbooks, which means that if you have a ... workbook, that last workbook will have Manual Calculation as well, no matter ... I then saved and closed the worksheet. ...
    (microsoft.public.excel.misc)
  • Re: #Value error when linking workbooks
    ... =countifwill work with open workbooks. ... You could use a different worksheet function: ... > workbook, ... > Does the Countif function enable source sheets to update automatically. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Why do I get Code Excution has been interupted
    ... Hit reset in VBE. ... Save and close the workbook. ... stops there next time around. ... 'Open workbooks ...
    (microsoft.public.excel.programming)
  • RE: minimize workbook
    ... I believe Excel keeps track of the order of all open workbooks. ... For example, if you had workbook ... "Workbook1" is the active window, ... Set wkbook2 = Range ...
    (microsoft.public.excel.programming)