+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    5

    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.
    Last edited by Deathwreaker; 05-30-2014 at 05:51 PM.

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

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

    Hi there,
    did You search ExcelForum?
    HTML Code: 
    http://www.excelforum.com/excel-programming-vba-macros/1013608-copying-2-columns-in-one-sheet-to-all-other-sheets-except-2-sheets.html
    HTML Code: 
    http://www.excelforum.com/excel-programming-vba-macros/1007579-macro-to-copy-data-from-specific-columns-and-rows-to-new-worksheet.html
    or try to record macro... It is a good thing to begin with.

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

    (If You like my solutions, feel free to add reputation.)

  3. #3
    Registered User
    Join Date
    05-29-2014
    Posts
    5

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

    I know this may sound extremely simple, but I'm having a hard time looking for the paper clip icon that allows me to attach my spreadsheet.

  4. #4
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

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

    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...

  5. #5
    Registered User
    Join Date
    05-29-2014
    Posts
    5

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

    Okay I'm trying to build an automated spreadsheet to get statistics I need for a competitive multiplayer videogame. I'm trying to copy columns O and Q from "Pokemon Statistics" into ranges B2 and C2 in "Usage Statistics". Once its copied, I want the columns autosorted in descending order and to keep sorting itself everytime I edit variables in "Pokemon Statistics", which affects the Usage Statistics column.

    My knowledge on Excel is limited, I got the copy part down but its copying the formulas and not the values. I'm having a hard time figuring out how to incorporate the PasteSpecial part into it. Once I sort that out, I'll get to the sorting part.

    Any help is appreciated.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

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

    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...)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to copy specific columns form one workbook to another
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2014, 11:53 PM
  2. how to copy specific columns form one workbook to another
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2014, 10:49 PM
  3. Copy specific columns from one workbook to another workbook
    By Tegpreet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2013, 07:55 AM
  4. [SOLVED] Copy columns by header value and paste them in a specific order into another workbook
    By KeriM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2012, 11:13 AM
  5. Copy specific columns and save into another workbook
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2008, 04:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1