maro to work on one sheet as opposed to all sheets in the workbook
 

Hi,

I am new to excel and have to debug and fix this problem written b
someone who left the company.
Well this excel workbook has lots of sheets and also sheets which hav
relevant data that gets used in the formula.

Now, say for eg lets considered the sheet called 'A'.

it does the calculations on the headcount needed for call center.
so the columns refer to a formula called gets() which then calls th
erlanc function.

Now the problem here is this gets() function takes a value called calc


and this calc just a cell in one of the sheets called table. Now if
change the headcount value in the sheet 'A' nothing happens. Then
need to change the value of calc cell say make it to 5 or 6 in shee
'table' and hit enter. It starts calulating the values to forecast th
headcount, but it does so for all the sheets . so it is taking a lot o
time.

So I have two problems here :
1Can someone tell me how to get make it calculate only for one sheet.
2what ever changes i do to say sheet 'A' and hit F9 or save it shoul
calculate for that sheet instead of going to sheet 'table' and changin
the calc value to trigger the recalculation.

PLease please help

help appreciated


--
gilligan
-----------------------------------------------------------------------
gilligans's Profile: http://www.excelforum.com/member.php...fo&userid=3502
View this thread: http://www.excelforum.com/showthread.php?threadid=54768