Need help with vba macro excel

[Suma_shankar]

@Logaraj Sekar
Vba macro to copy specific value from sheet 1 to sheet 2 in new rows upon changing of data in sheet 1
I have two sheets, sheet 1 n sheet 2 .I have to copy the specific value (say which is in column c) for the first largest number in column b and this process has to repeat for other two next largest numbers. And values must be copied to next row in sheet 2 upon refresh of sheet 1.Please help me with vba coding.

[#2]

Why do you need a macro? you can use SMALL(range, k) function to get the "k"th smallest and use LARGE(range,k) to get "k"th biggest value. avoid using VBA for the tasks you can do with functions, formulas and power query.