+ Reply to Thread
Results 1 to 5 of 5

linking specific data from one workbook to another

  1. 12-11-2013, 04:16 AM #1
    tocatech
    tocatech is offline
    Registered User
    Join Date
    12-11-2013
    Location
    cape town
    MS-Off Ver
    Excel 2013
    Posts
    3

    linking specific data from one workbook to another

    Hi Guys,

    Wondering if anyone could help me...
    I'm trying to link specific data from one workbook to another.
    So from the demo I've attahced, I need all of the 3rd row "ATP BASIC SERVICE : 1" to be linked to another workbook.

    So normaly I could copy the row, go to the other workbook, "paste special" and link it to a column.

    The only problem is the "ATP BASIC SERVICE : 1" data will not always be on the 3rd row.
    So i assume I would need to automatically search for "ATP BASIC SERVICE : 1" and if it is found, copy the column over to the other workbook.

    Can anyone tell me how to achieve this please.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-11-2013, 04:20 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: linking specific data from one workbook to another

    Hi and welcome to the forum jou ou kaapenaar
    SA ex-pat here.

    Did you intend to upload a csv file?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 12-11-2013, 04:22 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: linking specific data from one workbook to another

    Perhaps you could try using a vlookup() to get what you want?
    Reply With QuoteRegister To Reply
  4. 12-11-2013, 05:06 AM #4
    tocatech
    tocatech is offline
    Registered User
    Join Date
    12-11-2013
    Location
    cape town
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: linking specific data from one workbook to another

    Hi there, Howsit bru...lol

    Yeah i did.. but the data is changed so it's cool...
    Can you access this csv..?

    Do you think a vlookup will work?
    I'll look into it, but do you have like a sample for me to work from maybe
    Reply With QuoteRegister To Reply
  5. 12-11-2013, 05:12 AM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: linking specific data from one workbook to another

    hey man, lekker by die see, pity but die tides out lol

    Yes I opened the csv in excel, give this a try...
    =VLOOKUP("ATP BASIC SERVICE : 1",'report (1).csv'!C$2:R$7,3,0)

    You could change the ,3, to ,COLUMN(), IF you put that formula in column C (or some + or - to/from 3, if another column) that way you can just copy it across with no adjustments
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking Specific Keyword/Data (NOT CELL REFERENCE) to Another Workbook
    By CharlieTrey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2013, 02:39 PM
  2. Linking a workbook to external data from another excel workbook
    By Simon.Ward in forum Excel General
    Replies: 2
    Last Post: 03-07-2013, 05:18 AM
  3. linking specific data
    By tomvh444 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-03-2009, 12:34 PM
  4. Error Handling and linking VBA to specific workbook
    By Miraun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2009, 04:27 PM
  5. linking cell value to specific worksheet in the same workbook
    By lester in forum Excel General
    Replies: 0
    Last Post: 07-27-2006, 05:56 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1