I'm trying to make a macro that finds which cells in a column has the text, "Savings", then goes to the next active cell below it to copy/paste it to the next sheet.
I can't use the Offset command, because sometimes there are blank rows underneath Savings.
I've been messing with a few variations, but the closest one I have is this. It doesn't work though.
Please Login or Register to view this content.
Edit:
Also trying this, which I think is closer.
Please Login or Register to view this content.
Bookmarks