Hello all:
I need some help with automating some clean-up code.
I have a spreadsheet (see attached snippet) with a set number of columns, but the number of rows can change considerably.
What I'd love the code to do is:
Start in column D, find each entry (going down) that is NOT the Primary Borrower and delete the associated cell value in Column G (Exposure), looping until the only entries left under exposure are related to the Primary Borrower.
I imagine this would employ the offset function perhaps, but I'd love any ideas you have.
Thanks in advance!
I need some help with automating some clean-up code.
I have a spreadsheet (see attached snippet) with a set number of columns, but the number of rows can change considerably.
What I'd love the code to do is:
Start in column D, find each entry (going down) that is NOT the Primary Borrower and delete the associated cell value in Column G (Exposure), looping until the only entries left under exposure are related to the Primary Borrower.
I imagine this would employ the offset function perhaps, but I'd love any ideas you have.
Thanks in advance!