masterlodi
New Member
- Joined
- Jan 13, 2005
- Messages
- 3
I have a worksheet such as this
Column A Column B Column C
CompanyName John Time
CompanyName John Time
CompanyName John Time
CompanyName John Time <-- need this row
CompanyName Dave Time
CompanyName Dave Time
CompanyName Dave Time
CompanyName Dave Time <-- need this row
etc etc
How can I (using VBA) delete all but the last row for each person?
Any help is greatly appreciated.
Column A Column B Column C
CompanyName John Time
CompanyName John Time
CompanyName John Time
CompanyName John Time <-- need this row
CompanyName Dave Time
CompanyName Dave Time
CompanyName Dave Time
CompanyName Dave Time <-- need this row
etc etc
How can I (using VBA) delete all but the last row for each person?
Any help is greatly appreciated.