Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two work sheets, A and B. Need info from one sheet to the other | Excel Discussion (Misc queries) | |||
no sheet tabs on work sheets | Excel Discussion (Misc queries) | |||
CREATE MULTIPLE WORK SHEETS IN A WORKBOOK | Excel Worksheet Functions | |||
maro to save wooksheet & open in sheet 1 | Excel Worksheet Functions | |||
Links to other sheets only work if the sheet is opened | Excel Discussion (Misc queries) |