+ Reply to Thread
Results 1 to 7 of 7

Transfer Data To Another Worksheet And Create Hyperlink

  1. #1
    Registered User
    Join Date
    12-31-2010
    Location
    Kathleen, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Transfer Data To Another Worksheet And Create Hyperlink

    Rookie needs some help...

    I have a SaveAs macro that saves the worksheet into another workbook at a specified location. I need to add to the code. Would like to transfer data from one worksheet into the next available row in another worksheet. I have searched and seen multiple variations of this and I know this is probably cake for experienced programmers but I can't get it right. Is it also possible to create an automatic hyperlink in a cell based off my new saved location.

    To summarize what I am trying to do:

    Take data from cells N10:W10 in worksheet 'OPL MASTER' and transfer them to the next available row in worksheet 'OPL DATABASE'. I am trying to get it to create a hyperlink in the next available column that this data is tranferred to.

    Any help is appreciated!

    Please Login or Register  to view this content.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer Data To Another Worksheet And Create Hyperlink

    Transfer to OPL DATABASE into what column? It's not obvious that data from N:W would go into column A, so it's worth asking.

    Anyway, the copying part is simple enough:
    Please Login or Register  to view this content.

    As to the hyperlink.... hyperlink where? Hyperlink to what?


    This would be so much simpler if you just posted a sample workbook showing sample data and sample results including the hyperlink you're after.

  3. #3
    Registered User
    Join Date
    12-31-2010
    Location
    Kathleen, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Transfer Data To Another Worksheet And Create Hyperlink

    Thank you JBeaucaire...

    This works exactly as I had requested. This takes data from worksheet 'OPL' and transfers it to the first column of worksheet 'OPL Database' after the last entry.

    Is there a way to change this code so that data is transferred into the first available column instead of the first column after the last entry. In the database that I am trying to create I might have to clear some data from a row and I would want the next set of transferred data to go into this available slot.

    Also the hyperlink that I am trying to create is in column 'O' of worksheet 'OPL Database'. Basically user enters data from a multipage userform in worksheet 'OPL' and this data is transferred (thanks to your code) to 'OPL Database'. Once this data is transferred through the SaveAs macro, I am trying to get it to create a hyperlink to it's saved location.

    I have attached a copy of my workbook. If anyone can help me I would appreciate it. Hope I have explained what I am trying to accomplish well enough.

    Thanks


    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-31-2010
    Location
    Kathleen, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Transfer Data To Another Worksheet And Create Hyperlink

    Oops, forgot to attach my workbook...
    Attached Files Attached Files

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer Data To Another Worksheet And Create Hyperlink

    Try this:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-31-2010
    Location
    Kathleen, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Transfer Data To Another Worksheet And Create Hyperlink

    This works fantastic. I can't thank you enough.

  7. #7
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer Data To Another Worksheet And Create Hyperlink

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ 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