Good evening!
I'm averaging numbers that meet certain criteria in another worksheet. I would like a formula to reference that worksheet, without typing the name. I'm using the *&LEFT(QH$1,FIND(" ",QH$1)-1)&"*" formula to reference the cell in worksheet "EOY_Scores" that includes the string of text before the first space, which is "L.8.6". This allows me to drag the formula through the row without having to change the code that I want it to pull.
Here's where I'm stumped. I'd like to use something similar to this to reference that worksheet. For example, RIGHT(QH1,LEN(QH1)-SEARCH(" ",QH1)) would give "EOY_Scores", but is there a way to indicate that is the name of the worksheet?
Thanks in advance!
I'm averaging numbers that meet certain criteria in another worksheet. I would like a formula to reference that worksheet, without typing the name. I'm using the *&LEFT(QH$1,FIND(" ",QH$1)-1)&"*" formula to reference the cell in worksheet "EOY_Scores" that includes the string of text before the first space, which is "L.8.6". This allows me to drag the formula through the row without having to change the code that I want it to pull.
Here's where I'm stumped. I'd like to use something similar to this to reference that worksheet. For example, RIGHT(QH1,LEN(QH1)-SEARCH(" ",QH1)) would give "EOY_Scores", but is there a way to indicate that is the name of the worksheet?
Thanks in advance!