Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello -
I have report that shows customer account numbers and the date transactions occurred for that account. Some customers have more than one row on my spreadsheet because they have made more than one transaction. I only want to show the FIRST transaction each customer made and delete each subsequent one for each customer. Macros are fairly new to me, but what I want to do is sort the spreadsheet by account number, then transaction date (I know how to make the macro do that part) and then program the macro to delete any duplicate transaction rows per customer, leaving just that original transaction. I would really appreciate any help in accomplishing this. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with macro to save repeating data entry | Excel Discussion (Misc queries) | |||
How to insert a repeating dash in phone numbers without dashes in. | New Users to Excel | |||
Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
macro to eliminate spaces between words | Excel Discussion (Misc queries) | |||
How do I delete 100 account numbers from a spreadsheet colume wer. | Excel Worksheet Functions |