How to copy and sort information from one worksheet to another

[onlyonekj]

Hello,

I am new to the forum and VBA and need some help. I have a worksheet (Interview Scores) that list interview scores and would like to automatically copy and sort information from one worksheet to another. I have not tried anything because I really do not know where to start.

I only need column A (Names) and column D (Total Score), rows 1-25 to copy and sort to the new worksheet "Ranked Interview Scores" sorting by column D from largest to smallest.

I have attached a sample of the workbook. I hope I have not broken any forum rules and have provided everything necessary for assistance. I truly appreciate the help.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[onlyonekj]

John,

This worked really well. Thank you so much for your help. It is greatly appreciated!

[JOHN H. DAVIS]

You're welcome. Glad to help out, and thanks for the feedback.