Hi Otto.
I just need the ones for CA be copied to sheet2.
Now since I'm going to be adding new entry sales every day, the updated
buttom i guess will be perfect. It doesn't matter if i have two buttoms!

"Otto Moehrbach" wrote:

Karla
Are the rows for ALL the salesmen copied to the same sheet (sheet2 in
your post)? If not, how are the sheets identified as applying to one
salesman in particular?
Assuming that the destination sheet has more that one row with CA in it, and
you want to delete one row in sheet1 that has CA in it, how can the
corresponding row in sheet2 be identified as the one to delete?
One way, after you provide the info requested, would be to have 2 buttons at
the top of the sheet1, one labeled "Update" maybe, and the other "Delete".
The assigned macros would then operate on the active row of sheet1. HTH
Otto
"karla" wrote in message
...
I have a report (sheet1) where columns a, b, c ,d have sales info, and
column
e has the code of the salesmen like 2 for CA, 3 for AZ. what i need is a
macro that copy the entire row for the CA sales to a new worksheet
(sheet2).
but also need that if for some reason we have to delete a row for the CA
salesperson (sheet1) will be deleted on sheet2.
Can somebody help me?