+ Reply to Thread
Results 1 to 2 of 2

copy specific data from outside data source

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    copy specific data from outside data source

    I am trying to import partial data from an outside excel file. I have the code so far to open the outside Excel file but I can’t figure out how to copy only certain columns and rows of data.

    Please Login or Register  to view this content.
    Once the outside file has been opened, I need to copy as follows (without deleting any columns as I need the values to compute other data once I have this part working):

    copy column A (sourceWkb) to column A (destinationWkb)
    copy column C (sourceWkb) to column C (destinationWkb)
    copy column F (sourceWkb) to column D (destinationWkb)
    copy column H (sourceWkb) to column F (destinationWkb)
    copy column J (sourceWkb) to column G (destinationWkb)

    There is also one other criteria, which is the only copy rows in which the value in column G for the sourceWkb = “Chicago”

    I have attached a copy of data file and copy of file with desired results.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: copy specific data from outside data source

    Why dont u try this...


    click on data --> Get External Data. --> New Database query..

    Select Excel File

    Click on Ok and Follow the screen instruction.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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