Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows from one worksheet to another using macros
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows from one worksheet to another using macros
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows from one worksheet to another using macros
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" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows from one worksheet to another using macros
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" wrote: 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" wrote in message ... 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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows from one worksheet to another using macros
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 "karla" wrote in message ... 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" wrote: 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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move/Copy Worksheet with Macros | Excel Discussion (Misc queries) | |||
Mastersheet to Worksheet data copy - macros? | Excel Discussion (Misc queries) | |||
Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
Copy Worksheet Not the Macros | Excel Programming | |||
Using macros to cut & paste rows to a new worksheet | Excel Programming |