Trying to do this in VBA so I can use a button to do all at once.

Example: I have a sheet named payouts. Another named results.

What I would like to do is select a cell in the range AB2:ab100 on payout sheet (this range is all text cells)and check one at a time (ie ab2, then ab3, etc)

I would then like to search on results sheet and find the match to the cell on payout sheet. Once that match ( there will always be a match) is found then offset by 2 rows, copy that information, then past that information (number) back to the payout sheet.

Thanks

Buddy