Hello,
I hope someone can help.
I have a sheet of data (Sheet1) which I need to manipulate using VBA. I want to keep the existing data (for sanity checking) and generate an amalgamated version on a new sheet.
The rules are quite straightforward:
(a) if an asset has a freehold status only...