Hi guys - Not sure if this is possible but I would like to create a macro that loops through rows of data and zeroizes any data that has already been captured by a a previous line.
Ive attached a file to give you an idea of the raw data Im working with and the preferable end result. Relates to projected payments. Essentially, I would like only one Year/Month column (B:Y) per ID (A) to hold data with column Z indicating when the payment occurred.
Any ideas or help you may be able to offer would be greatly appreciated.
Thanks!
Bookmarks