Reference a worksheet name as a cell value in another worksheet

[tantcu]

Hi.

I have a code

Please Login or Register  to view this content.

The number 2429 = Cell C3 in Worksheet("BAT")

Is there a way that I can reference it without directly using the number 2429?

[Trebor76]

Hi tantcu,

Is this what you're after:

Please Login or Register  to view this content.

Robert

[tantcu]

Thank you so much Robert. You don't mind if I can ask one more question. Instead of Vba, if I have a formula like this : =SUMIF('2429'!$C$14:$C$363,BAT!$E48,'2429'!$F$14:$F$364). Because it has to reference a sheet "2429". This sheet populate based on cell C3 of worksheet BAT. Everytime C3 is changing the sheet will disappear and populate another sheet. I want this formula apply to all the sheet as possible. Is there a way that I can reference the number 2429 in the formula above to something else so I don't have to worry about changing the sheet. Thank you.

[Trebor76]

Try this:

=SUMIF(INDIRECT("'"&BAT!C3&"'!$C$14:$C$363"),BAT!E48,INDIRECT("'"&BAT!C3&"'!$F$14:$F$363"))

Robert