Re: new cell for each day

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

=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
.

Relevant Pages

  • RE: Linking in Excel
    ... Find links in a workbook ... To select the cell with a link, select the row in the box at the bottom. ... Creates a shortcut or jump that opens a document stored on a network server, ... When you click the cell that contains the HYPERLINK ...
    (microsoft.public.excel.misc)
  • RE: Linking in Excel
    ... Find links in a workbook ... To select the cell with a link, select the row in the box at the bottom. ... Creates a shortcut or jump that opens a document stored on a network server, ... When you click the cell that contains the HYPERLINK ...
    (microsoft.public.excel.misc)
  • Re: convert hyperlink to email address
    ... Copy/fill that formula down to the end of the list of email addresses (Cell ... I use the terms workbook and file interchangeably. ... A "Stop Recording" toolbar should appear somewhere. ... in the Project Explorer and it will have a "Modules" folder in it with and ...
    (microsoft.public.excel.programming)
  • Re: New numbers
    ... Private Sub CommandButton1_Click ... 'Automatically inserts today's date in cell in column C when selected ... I am sure I do not have a workbook named as such. ... sheet in your Wb and set the caption property name to "Add Invoice ...
    (microsoft.public.excel.worksheet.functions)
  • Re: New numbers
    ... I don't know why I wrote that I did not have an "Invoice Number.xls" since ... Private Sub CommandButton1_Click ... 'Automatically inserts today's date in cell in column C when selected ... I am sure I do not have a workbook named as such. ...
    (microsoft.public.excel.worksheet.functions)