Hi guys,
I have a sheet which will constantly be changing. The sheet lists users and the users I need can be determined by a specific row that is 2 rows below their ID.
Basically what I need is a VB script that will perform a find command for a specific phrase. Once it finds that phrase it will move up two rows (where the id is located), copy the data from that cell, paste it into the next cell on a second sheet, and then return to sheet one and continue performing the find command for the next instance of that specific phrase (skipping the one it just found before moving up 2 cells).
As an example lets say the phrase is "This user" If the sheet were broken out like it is below, I basically need sheet2 to list Ryan, Aaron, and Mike on seperate rows (e.g. A1, B1, C1 on sheet2). Any help you can provide would be greatly appreciated.
Ryan
Ab1
This User
True
Bob
Ab2
Not Him
True
Aaron
Ab3
This User
False
Eric
Ab4
Orange
True
Mike
Ab5
This User
True
Bookmarks