| 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? |
| 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 | |||
Threaded Mode
