Forum Discussion
Suma_shankar
Jun 06, 2020Copper Contributor
Need help with vba macro excel
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...
erol sinan zorlu
Jun 07, 2020Iron Contributor
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.