Change Formula

[Guest]

I was wondering if it's possible to modify this formula to make it load the
current active sheet instead of the current "month-day" like the way I have
it right now?

=IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130")<>FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130"),"")

Is there a method like the VBA "ActiveSheet" for cell formulea?

Thanks In Advance,
Rob

 

[FunkySquid]

I don't think there is an inbuilt function to find it exactly so I've
used a combination to get the result of the sheet name:

=RIGHT(CELL("filename"),
LEN(CELL("filename"))-FIND("]",CELL("filename")))

Hope this helps.

FunkySquid

 

[Guest]

FS,

Just to make certain I understand correctly... "filename" should be the name
of the workbook and "CELL" should be the cell that I'm getting the info from;
my example below...

=RIGHT(A130("ItmHndl.xls"),
LEN(A130("ItmHndl.xls"))-FIND("]",A130("ItmHndl.xls")))


Thanks for your help,
Rob

I don't think there is an inbuilt function to find it exactly so I've
used a combination to get the result of the sheet name:

=RIGHT(CELL("filename"),
LEN(CELL("filename"))-FIND("]",CELL("filename")))

Hope this helps.

FunkySquid

I was wondering if it's possible to modify this formula to make it load the
current active sheet instead of the current "month-day" like the way I have
it right now?

=IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130")<>FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130"),"")

Is there a method like the VBA "ActiveSheet" for cell formulea?

Thanks In Advance,
Rob

 

[Dave Peterson]

Nope.

Just try the original suggestion.

FS,

Just to make certain I understand correctly... "filename" should be the name
of the workbook and "CELL" should be the cell that I'm getting the info from;
my example below...

=RIGHT(A130("ItmHndl.xls"),
LEN(A130("ItmHndl.xls"))-FIND("]",A130("ItmHndl.xls")))

Thanks for your help,
Rob

I don't think there is an inbuilt function to find it exactly so I've
used a combination to get the result of the sheet name:

=RIGHT(CELL("filename"),
LEN(CELL("filename"))-FIND("]",CELL("filename")))

Hope this helps.

FunkySquid

I was wondering if it's possible to modify this formula to make it load the
current active sheet instead of the current "month-day" like the way I have
it right now?

=IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130")<>FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130"),"")

Is there a method like the VBA "ActiveSheet" for cell formulea?

Thanks In Advance,
Rob

 

[Guest]

OK, so how do I incorporate this code....

=RIGHT(CELL("filename"), LEN(CELL("filename"))-FIND("]",CELL("filename")))

into or with this code....

=IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A70")<>FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) & "'!A70"),"")

Because if I just copy/paste it it doesn't seem to work. So I am wondering
where I use the suggested code?

Thanks Much.
Rob

Nope.

Just try the original suggestion.

FS,

Just to make certain I understand correctly... "filename" should be the name
of the workbook and "CELL" should be the cell that I'm getting the info from;
my example below...

=RIGHT(A130("ItmHndl.xls"),
LEN(A130("ItmHndl.xls"))-FIND("]",A130("ItmHndl.xls")))

Thanks for your help,
Rob

I don't think there is an inbuilt function to find it exactly so I've
used a combination to get the result of the sheet name:

=RIGHT(CELL("filename"),
LEN(CELL("filename"))-FIND("]",CELL("filename")))

Hope this helps.

FunkySquid

Rob wrote:
I was wondering if it's possible to modify this formula to make it load the
current active sheet instead of the current "month-day" like the way I have
it right now?

=IF(INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130")<>FALSE,INDIRECT("'" & MONTH(NOW()) & "-" & DAY(NOW()) &
"'!A130"),"")

Is there a method like the VBA "ActiveSheet" for cell formulea?

Thanks In Advance,
Rob