Automate a date referenced in a formula pointing to another sheet
 

I am trying to reference a date in a formula that points to a sheet name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that value in
the date for column B? Column B is the name of a different sheet in the
workbook.

Automate a date referenced in a formula pointing to another sheet
 

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that value in
the date for column B? Column B is the name of a different sheet in the
workbook.

Automate a date referenced in a formula pointing to another sh
 

Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that value in
the date for column B? Column B is the name of a different sheet in the
workbook.

Automate a date referenced in a formula pointing to another sh
 

hmm, everything is ok at me. Are your target worksheet have name in mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that value
in
the date for column B? Column B is the name of a different sheet in
the
workbook.

Automate a date referenced in a formula pointing to another sh
 

Thank you for your help,

It is formated as a date. November 11, 2005.. When I use the Evaluate
button, it shows the correct figure (in Parinithies) but the cell shows REF
Error. It is changing the date to Julian, then back to the format defined,
but then an error.

Any Thoughts?


"Mladen_Dj" wrote:

hmm, everything is ok at me. Are your target worksheet have name in mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that value
in
the date for column B? Column B is the name of a different sheet in
the
workbook.

Automate a date referenced in a formula pointing to another sh
 

maybe it's sintax??

The bigining "'" in =INDIRECT("'" is quotes-apostrophe-quotes, and "' is
quotes-apostophe in "'!$V$35

I'm tested formula few times and it works 100%.


"Birt36" wrote in message
...
Thank you for your help,

It is formated as a date. November 11, 2005.. When I use the Evaluate
button, it shows the correct figure (in Parinithies) but the cell shows
REF
Error. It is changing the date to Julian, then back to the format
defined,
but then an error.

Any Thoughts?


"Mladen_Dj" wrote:

hmm, everything is ok at me. Are your target worksheet have name in
mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It
should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that
value
in
the date for column B? Column B is the name of a different sheet in
the
workbook.

Automate a date referenced in a formula pointing to another sh
 

Thank You for the help.

I am mailing you the exact formula in my cell. Please tell me somethings
wrong with it.....

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$23")

Thank You Again.

"Mladen_Dj" wrote:

maybe it's sintax??

The bigining "'" in =INDIRECT("'" is quotes-apostrophe-quotes, and "' is
quotes-apostophe in "'!$V$35

I'm tested formula few times and it works 100%.


"Birt36" wrote in message
...
Thank you for your help,

It is formated as a date. November 11, 2005.. When I use the Evaluate
button, it shows the correct figure (in Parinithies) but the cell shows
REF
Error. It is changing the date to Julian, then back to the format
defined,
but then an error.

Any Thoughts?


"Mladen_Dj" wrote:

hmm, everything is ok at me. Are your target worksheet have name in
mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It
should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that
value
in
the date for column B? Column B is the name of a different sheet in
the
workbook.

Automate a date referenced in a formula pointing to another sh
 

I was copy it, and it works for me... well i realy can't explain than... if
you have datevalue for 11 November 2005 in cell A1, and other worksheet
named 11-11-05 it should work because here works without any problems...
Strange... I wish I can help you more

"Birt36" wrote in message
...
Thank You for the help.

I am mailing you the exact formula in my cell. Please tell me somethings
wrong with it.....

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$23")

Thank You Again.

"Mladen_Dj" wrote:

maybe it's sintax??

The bigining "'" in =INDIRECT("'" is quotes-apostrophe-quotes, and "' is
quotes-apostophe in "'!$V$35

I'm tested formula few times and it works 100%.


"Birt36" wrote in message
...
Thank you for your help,

It is formated as a date. November 11, 2005.. When I use the Evaluate
button, it shows the correct figure (in Parinithies) but the cell shows
REF
Error. It is changing the date to Julian, then back to the format
defined,
but then an error.

Any Thoughts?


"Mladen_Dj" wrote:

hmm, everything is ok at me. Are your target worksheet have name in
mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It
should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a
sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that
value
in
the date for column B? Column B is the name of a different sheet
in
the
workbook.

Automate a date referenced in a formula pointing to another sh
 

I don't understand it either. Is it possible for you to email, or attach a
copy of your working spreadsheet?

"Mladen_Dj" wrote:

I was copy it, and it works for me... well i realy can't explain than... if
you have datevalue for 11 November 2005 in cell A1, and other worksheet
named 11-11-05 it should work because here works without any problems...
Strange... I wish I can help you more

"Birt36" wrote in message
...
Thank You for the help.

I am mailing you the exact formula in my cell. Please tell me somethings
wrong with it.....

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$23")

Thank You Again.

"Mladen_Dj" wrote:

maybe it's sintax??

The bigining "'" in =INDIRECT("'" is quotes-apostrophe-quotes, and "' is
quotes-apostophe in "'!$V$35

I'm tested formula few times and it works 100%.


"Birt36" wrote in message
...
Thank you for your help,

It is formated as a date. November 11, 2005.. When I use the Evaluate
button, it shows the correct figure (in Parinithies) but the cell shows
REF
Error. It is changing the date to Julian, then back to the format
defined,
but then an error.

Any Thoughts?


"Mladen_Dj" wrote:

hmm, everything is ok at me. Are your target worksheet have name in
mm-dd-yy
format for sure and does date in A1 is value (number) or text ?? It
should
be value, othervise you must convert it to value...VALUE(A1).

"Birt36" wrote in message
...
Thank You.

But it did not work. I get a REF Error in the cell.

"Mladen_Dj" wrote:

try with formula (suppose date is in cell A1):

=INDIRECT("'"&TEXT(A1,"mm-dd-yy")&"'!$V$35")


"Birt36" wrote in message
...
I am trying to reference a date in a formula that points to a
sheet
name.
See Below.

A B
November 11, 2005 ='11-11-05'!$v$35

How can I automate the date to pull from column A and place that
value
in
the date for column B? Column B is the name of a different sheet
in
the
workbook.

Automate a date referenced in a formula pointing to another sh
 

Just send me e-mail to mister.guroREMOVE[at]gmail.com and I will send you my
workbook...


"Birt36" wrote in message
...
I don't understand it either. Is it possible for you to email, or attach a
copy of your working spreadsheet?