copy rows from one worksheet to another using macros

[karla]

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?

 

[Otto Moehrbach]

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]

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]

Karla
You didn't answer my question about what you do when you want to delete
an entry in sheet1. You said that you want the same row in sheet2 deleted.
If you were doing what you want manually, how would you determine which row
in sheet2 you want to also delete? Otto

 

[karla]

Otto:
i'm sorry here is what i need:
sometimes the customers call us saying that they want to cancel the order.
so i have to delete that particular sales entry in sheet1. becuase that
particular sale already existis in sheet2, i want that be deleted in sheet2
too once i deleted in sheet1.
That is why i need a macro that copy the sales from CA to sheet2 and can
updated the sales; because i won't know how many sales i'll be deleting.

thank you very much for your time.. i really appreciate it!

 

[Otto Moehrbach]

Karla
We're on a merry-go-round.
Say you make an entry in sheet1 and hit the Update button. That copies that
row to sheet2. Later, you go to sheet1 and put your cursor anywhere in the
row you want to delete and hit the Delete button. The code deletes that row
and then goes to sheet2 and looks for the row to delete in that sheet. I
assume sheet2 will have more than 1 entry with CA. Perhaps that's not a
good assumption.
The question: How would you find the right row to delete in sheet2 if you
were doing this manually? I think the answer to this is very simple to you
but, not knowing your business, it's not very simple to me. Otto