Conditional Copy paste with NEXT and BACK Button

[nasrullah]

Dear Team,

In my sheet (photo in the link), i have data from A1:F20.
Column A got Primary Key (Pkey). When i select the Pkey cell range and press the button (button code as below) it copy paste the selected cells to Range H2 on wards. Then a vlookup fill my my other columns (I:K) data.
Its marking the font color red - So i know which i select before.

Now, i need a the button to paste the Pkey only if if the column F = Yes.

Second, i need a next and previous buttons code to select group of primary key which has the same code (in column B)

Sub Button1_Click()
 Sheets("sheet1").Range("h2:G20").Clear
    Selection.Cells.Font.Color = RGB(256, 0, 0)
    Selection.Copy
    Sheets("Sheet1").Range("h2").PasteSpecial Paste:=xlPasteValues
    
    Application.CutCopyMode = False
End Sub

These are test data not real data or person name.
https://ibb.co/MnKDZ90
https://ibb.co/stx1SRF

 

[nasrullah]

I am posting after very long time, if any mistake i did or again any forum rule, please advise.
i could not attache my sample file here.