| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
matching and deleting
i have two work sheets in one spreadsheet. they are from different systems
one feed to the second to create refunds. I have been forced to cut and paste both sheets to a new worksheet and then sort by amount and then delete like amounts to find refunds not carried over to the other system. Is there an easier way to match and then delete matching amounts, therefore saving me valuable time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete all matching rows | Excel Discussion (Misc queries) | |||
| Deleting specific records from a column | Excel Discussion (Misc queries) | |||
Threaded Mode
