move specific values from one column to another - macro request

[missy22]

Dear all,

I am writing to seek help, in creating a macro, which can find specific values from column F and if those values (conditions) equal true in column F, then copy column F and G and paste it into column H & I.

Here are the conditions:
if (F) int values >= 125(whole number)
copy. cell(F)&(G) = paste.cell(H)&(I)

else if (F) string values >= alphabet+(int value) *
copy. cell(F)&(G) = paste.cell(H)&(I)

else if (F) string values >= +(int value) *
copy. cell(F)&(G) = paste.cell(H)&(I)


(*) - i.e. N+100, ASW+70s,

(*) - i.e. +900, +34s

the 3 conditions are:
if column F, contains whole number greater than 125, then copy the value from column F and the same row cell of Column G, and paste it into column H and I.

if column F, contains string value where it has alphabet and plus sign and number after that, then extract that value and paste it into column H and I (same row).

if column F, contains string value where it has plus sign and number after that, then extract that value and paste it into column H and I (same row).

I have attached a sample data in the file below, showing input data and desired output in another sheet, for further reference. The workbook follows the logic from the conditions stated above.
test_1.xls

Thank you very much for any help provide.
Kind regards

[missy22]

Hi, could anyone please provide a little guide, as to how I can get started with the above threat post.

Much appreciated. Thanks