If I have a list of employees in column A2 to A13 and a list of percentages in col B2 to B13, how can I create a macro to select the highest percentage in the range B2 to B3 and then copy that entire row and paste it to a new sheet?
I think a MAX and if statement could be used but I am not sure of how exactly to write the code.
Something along the lines of:
select max from B2 to B13 of (Sheet 1) and copy/paste entire row in first blank cell of col A in sheet 2
Thanks for the help
Bookmarks