Sep 23 2021 08:26 AM - edited Sep 23 2021 08:31 AM
I have worksheet called PTW1 and I also have other worksheet called 1
In cell D2 have this formula
=IF('1'!D2<>"",'1'!D2,"BWT")
=IF('1'!G2<>"",'1'!G2,"BWT")
When I delete worksheet called 1 I getting #REF in D2 & G2 formulas before
I do not want #REF anymore when I delete 1. Next Year I create new 1 worksheet.
=IF(#REF!D2<>"",#REF!D2,"BWT")
=IF(#REF!G2<>"",#REF!G2,"BWT")
I want hard code vba have both formulas in code. and basic code
Thanks You
Sep 23 2021 09:17 AM
Sep 23 2021 10:22 AM - edited Sep 23 2021 11:54 AM
Solutionfunction INDIRECT()
=IF(INDIRECT("'1'!D2")<>"",INDIRECT("'1'!D2"),"BWT")
=IF(INDIRECT("'1'!G2")<>"",INDIRECT("'1'!G2"),"BWT")
That I do for G2?
Thanks You
Sep 23 2021 12:59 PM
Sep 23 2021 03:36 PM - edited Sep 23 2021 03:42 PM
The function doesn't work it is in red can check wrong. if possible can send copy of file
Thanks You
Sep 23 2021 07:04 PM
@sf49ers19238597 works for me (see attached).
Sep 24 2021 12:44 AM
Sep 24 2021 05:20 AM
Sep 24 2021 11:35 AM - edited Sep 25 2021 12:35 AM
Thanks You for formulas It is working now.
Sep 23 2021 10:22 AM - edited Sep 23 2021 11:54 AM
Solutionfunction INDIRECT()
=IF(INDIRECT("'1'!D2")<>"",INDIRECT("'1'!D2"),"BWT")
=IF(INDIRECT("'1'!G2")<>"",INDIRECT("'1'!G2"),"BWT")
That I do for G2?
Thanks You