Excel 2007 : Using a cell to refer to a specific tab

[qaliq]

I am trying to set up a spreadsheet where I have a number of different tabs each containing the same data (it is basically costs associated with a number of different sites). I want to be able to turn on or off certain sheets so they are either included/excluded in a calculation (so I can sum by region/manager etc.).

I have a summary sheet that looks like this:

A1	A2	A3
Site Name	Tab Name	Included?
Aberdeen	Adeen
Kirby Lonsdale	KLons
North Wales	NWales

In each worksheet I have a cell (Z10)which basically says included/excluded, so I was intending on writing an if statement in the included column in my my summary here to summarise. So i don't have to write 20 odd seperate if statements is there a way that I can somehow use the tab name cells to refer to a cell...

e.g. IF(B3!Z10="included", "yes", "no")....if I try and do this though I get a cell reference error

Is this possible? Hopefull I've explained myself properly!

Thanks

[dilipandey]

Hi qualiq,

To reference a worksheet name from a cell, you can use indirect function, but I believe this is not what you are looking for, though this function can be used somewhere which will help you to get the resolution.

Would suggest you to post a sample file. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[qaliq]

That's great, I've got it to work now using the indirect function.

Thanks for your help!

[dilipandey]

you are welcome qaliq..

cheers

Regards,
DILIPandey

<click on below 'star' if this helps>