Hi there,
I’m trying to use the Find function in VBA, with not much luck.
I have a sheet of data, and I’d like to be able to find text in column A (“Growthpoint”) and move each occurrence (entire row) of that word up to underneath the first occurrence.
And then insert a blank row underneath the grouping.
Please refer to “Before” and “After” attachments.
I’d appreciate any help, been stuck on this for days!
Thank you.