You could record a macro while you copy the ranked column F and 'paste
special' the values into column J
You could then use the macro (with a command button) whenever needed.
--
Traa Dy Liooar

Jock


"vijaydsk1970" wrote:

I have an excel sheet with rank formula used in column F. i want pick up
first 12 ranked rows (entire cells from Column A to Column F) and copied into
column J to column L. Any speedy help will be highly appreciated. Thanks in
Advance