Hi Guys! I hope you are all doing well!
I was hoping if you could help me with the idea I have for my sheet which should be quite simple but I can't seem to find any guides online.
Basically I have this Sheet with a:
- Homepage
- Surrenders
- Lapsing
- Maturities
- Settled
Now what I want is, to create a button on the homepage sheet and assign a macro to it. I want this macro to move all rows from sheets Surrenders, Lapsing and Maturities that have Status (Column F) set as "Handed to Finance" to the sheet Settled.
Would you please be able to help me? Thanks in advance
Bookmarks