move data between sheets & keep running total

M

miker1999

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move between sheets & keep a running total 2
Macro to Compile Data from Different Sheets 2
Copy to end of sheets, another file 1
IF Statement based on first two characters of cell 4
Team Frame Fill and Arrows 0
Populating entire rows of data from a master sheet? 3
Format Pivot total rows 2
need code to copy/move data between sheets 3

Top