+ Reply to Thread
Results 1 to 2 of 2

Extracting specific columns

  1. #1
    Registered User
    Join Date
    02-23-2017
    Location
    Seattle
    MS-Off Ver
    Mac 15
    Posts
    24

    Extracting specific columns

    Hi-

    Each month I download a report from my bank in .csv file format. Then I open it in excel and delete a bunch of columns so I have just the ones I want and them copy them in the same order into a workbook I have had for years.

    My question is, what is the easy way to just take columns A,G,I,L,U, AJ from my file opened in excel so I can manually copy them to a new page in my workbook?



    Thanks.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Extracting specific columns

    What have you tried?

    Select column A, then press and hold Ctrl while selecting all of the other columns. Copy. Now go to the new tab and paste as values.
    HTH
    Regards, Jeff

+ 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. [SOLVED] Extracting Data from Word Table to Excel 2013 into specific columns
    By achieve1 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2017, 12:41 AM
  2. Replies: 1
    Last Post: 06-08-2016, 10:19 PM
  3. [SOLVED] Extracting specific values into new columns - any ideas?
    By Brickinnit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2015, 06:22 AM
  4. Replies: 5
    Last Post: 08-07-2015, 08:56 AM
  5. Need help extracting data from internet explorer and putting it in specific columns
    By dangerdavedsp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2013, 12:39 PM
  6. Replies: 2
    Last Post: 06-18-2013, 12:15 PM
  7. Replies: 2
    Last Post: 04-04-2013, 12:26 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