B
Brian
I have a workbook that has seven worksheets "open", "closed", "area1",
"area2", "area3", "area4", "area5". On worksheet "open" each row will have a
column range b2,b2000 labled "area" that I will be putting in one of the
five areas (1-5). The "open" worksheet will also have another column range
i2,i2000 listed as "active" which will have either a "y" or an "n".
So this is what I need.
1. I need the entire row to copy and paste over to the corresponding
worksheet listed in b2,b2000 when I tab out of the "area" column (column b)
after entering in the appropriate erea information in the "area" column.
2. When we put a "n" in the "active" collum we need the information to cut
and paste into the "closed" worksheet. This should in turn cause the
information to removed from the corresponding "area" (1-5) worksheets.
3. In the "closed" worksheet if we put a "y" in the "active" cloumn it
should cut and paste the row information back into the "open" worksheet.
"area2", "area3", "area4", "area5". On worksheet "open" each row will have a
column range b2,b2000 labled "area" that I will be putting in one of the
five areas (1-5). The "open" worksheet will also have another column range
i2,i2000 listed as "active" which will have either a "y" or an "n".
So this is what I need.
1. I need the entire row to copy and paste over to the corresponding
worksheet listed in b2,b2000 when I tab out of the "area" column (column b)
after entering in the appropriate erea information in the "area" column.
2. When we put a "n" in the "active" collum we need the information to cut
and paste into the "closed" worksheet. This should in turn cause the
information to removed from the corresponding "area" (1-5) worksheets.
3. In the "closed" worksheet if we put a "y" in the "active" cloumn it
should cut and paste the row information back into the "open" worksheet.