+ Reply to Thread
Results 1 to 5 of 5

Hyperlink VLOOKUP, Copying different columns by order from hyperlink doc to another.

  1. 03-07-2012, 02:41 AM #1
    m_oioisju
    m_oioisju is offline
    Registered User
    Join Date
    03-01-2012
    Location
    Macedonia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Hyperlink VLOOKUP, Copying different columns by order from hyperlink doc to another.

    I need hyperlink vlookup and some copy paste formulas help.


    Hello first of all to all of you and i need help cause i am excel newbie and need to get this dont till i learn how to use
    excel formulas properly and decently. I need this help to save me some time at work cause i need to retype many things that
    are kind of same in 2 different excel documents.
    Please be a little patient and look the example with the attachments and read what i've typed below:




    When i type in collumn D a serial number like 512-15, the number 512-15 to be found in Book 1 and the numbers from the row to be coppied
    in Book2 in the same row but only by following order:


    The date typed in column "J" in Book1 to be copied in Column "A" of book2

    The numbers in columns "E, F, G" of Book2 to be equal to numbers in columns "B, C, D" of the row where serial number 512-15 is written.

    By the same order columns "I" and "J" of Book2 to be equal to columns "F" and "J" of Book2

    Column "B" in Book2 to be the same text typed in column "M" in Book1

    Column "C" in Book2 to be the same number or text as column "K" in Book1.



    And if possible the number in Column "L"of Book2 to be generated like this:
    If first number of the serial 512-15 is 5.....the number to be 5
    but if number of the serial is 1112-14, the number in the column "L" to be 11.
    If that's not possible at all it's not big proble,


    Please tell me how to create the hyperlink and do this formula or command with vlookup or anything else.
    I am losing too much time at work to retype everything that's why i need to solve this issue so that it will not take too much time.
    Thanks in advance to anyone that can help me.
    Attached Files Attached Files
    Last edited by m_oioisju; 03-07-2012 at 07:20 AM. Reason: MOVED to Excel programming
    Reply With QuoteRegister To Reply
  2. 03-07-2012, 05:33 AM #2
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Hyperlink VLOOKUP, Copying different columns by order from hyperlink doc to another.

    Hi

    Here the file.

    It would be lot better do it in 1 workbook.

    I explain in m_oioisju2 book.
    Have look.
    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-07-2012, 06:19 AM #3
    m_oioisju
    m_oioisju is offline
    Registered User
    Join Date
    03-01-2012
    Location
    Macedonia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Hyperlink VLOOKUP, Copying different columns by order from hyperlink doc to another.

    Thanks but it's not correct for what i need.
    I need the exact numbers from my original book1 first of all, and on book2 i only want to type the serial number 512-25 for example, and all other data to be entered automatically from the book1.
    I know that it's better to use one book but unfortunately my work requires 2 books instead of one.
    In book1 i enter everything manually and in book2 i need automated copy paste values from columns and rows as i explained and need to be exactly same from book1.
    For example when i just type manually the serial 512-25 in book2, all other fields to be filled automatically from the information of the serial in book1.
    If you could help me it will be much appreciated.
    Reply With QuoteRegister To Reply
  4. 03-07-2012, 07:02 AM #4
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Hyperlink VLOOKUP, Copying different columns by order from hyperlink doc to another.

    I done in Hyperlink.
    Book 1. This does type in 512-25. Click Go to Record will automatic go to book 2 number

    But if you looking for automatic copy and paste. Then you need VBA. I no good in VBA.
    You need to go to Excel Programming forum for this.

    What I done in vlookup. Sample You put manually in book 1. Book 2 lookup from book 1. That way you don't have to manually in book 2.

    This is best I can do for you. Unless anyone come up with any idea?

    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-07-2012, 07:06 AM #5
    m_oioisju
    m_oioisju is offline
    Registered User
    Join Date
    03-01-2012
    Location
    Macedonia
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Hyperlink VLOOKUP, Copying different columns by order from hyperlink doc to another.

    Thanks gonna ask help for VBA cause i dont need automaticaly data to be entered in book2
    Because book2 is for other reasons then book 1 not the same as book1.
    Thanks for giving me directions where to post this mate.
    Cheers
    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)

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