Copy Two Specific Columns from One Spreadsheet to Another in the Same Workbook

Hi. I am new to the forums and looking to learn how to use VBA. I'm pretty sure the answer to this is somewhere but I'm lost as to where to start looking.

I'm looking to write a macro code that copies two specific columns to a separate spreadsheet in the same workbook, and then sort the rows by values in ascending order.

Any ideas on potential references I could start looking from? Kinda lost and could use the help.

Thanks.

Hi there,
did You search ExcelForum?

HTML Code: 

HTML Code: 

or try to record macro... It is a good thing to begin with.

or upload a sample workboook, with description what to do...

Below this Quick Reply window, on the right side, there You will find 'Go Advanced'. Click the button an there You will find paper clip icon...

Hi there,
if You do not mind, I write my code in to Yours started and add sorting:

Please Login or Register  to view this content.

Depends on when You want to copy and sort, You can do that manualy by pressing button(which You create somewhere on the source sheet), or You assign that code to some of worksheet events (Change, SelectionChange, Activate...)