move data between sheets & keep running total
 

Hello all,
I have a workbook with 4 sheets:
Sheet 1 = OPEN positions
Sheet 2 = just FILLED positions
Sheet 3 = current ACTIVE positions
Shhet 4 = Total # allowed for positions

I have a formula that adds the # in OPEN + # of current ACTIVE t
ensure that it equals # allowed. Once a position is filled, I move i
to FILLED (where I store my long list of every position ever filled)
How can I accomplish 2 things:

Move the entire row of data from OPEN sheet to FILLED sheet when
switch the data in column A (from 'OPEN' to 'FILLED')...is this
change event? I would like the data to move automatically and only pas
the values, not the formulas.

Second, I would then like to add '1' to the position in the Curren
ACTIVE sheet so that I can keep the running total.

Help...I am very stuck.
Thanks,
Mik

--
Message posted from http://www.ExcelForum.com