Excel Auto Move Cell Information

[roger68]

I have two columns containing data on an Excel worksheet. On sheet 3 of the Excel file, I have some data. The first column, Column C, contains numbers ranging from 102 to 431, and these are employee numbers. The second column, Column D, contains random numbers from 0 to 5,000. Each row in Column D is associated with a corresponding row in Column C. I would like to automatically copy the top 25 employee numbers from Sheet 3, Column C to Sheet 1, Column A. The top 25 employees are identified by the 25 highest values in corresponding Column D.

Ideally, I would like to copy all employee numbers that are associated with a non zero value from Sheet 3 to Sheet 1. Is it possible to only copy the employee numbers associated with a non-zero value? I'm using Excel 2007.

Thanks for your help!

 

[Simon Lloyd]

just record yourself autofiltering column D for the top 25 copy what you want and paste to the sheet you want, you will have at least gone some way to helping yourself, you can then post the code here and we'll help you further with the rest.

 

[roger68]

Hello Simon,

This gives me a great fall back idea. Thanks. I didn't want to use the autofilter, but it's definitely an option.