Thread: copy rows from one worksheet to another using macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karla Karla is offline
external usenet poster
  
Posts: 9
Default copy rows from one worksheet to another using macros
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?
Reply With QuoteReply With Quote