+ Reply to Thread
Results 1 to 6 of 6

Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2010
    Posts
    3

    Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

    I have a mileage table that has distance values between two airports this worksheet is called "Mileage Chart" I have a second worksheet called "Mileage Calculator where the user inputs the origin and destination airport codes and the Macro should reference the "Mileage Chart" worksheet and return the intersecting value. I have gotten the Macro to work when it is placed in the "Mileage Chart" worksheet but I would like to have the Macro run from the "Mileage Calculator" worksheet. Can someone show me how to do this? Here is my code and my spreadsheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by coa747400; 05-16-2014 at 02:53 PM.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

    Hello coa747400,

    Welcome to the Forum.

    Moderation removed. Thank you for adding Code Tags.

    We all have to abide by the Rules.

    Regards.
    Last edited by Winon; 05-17-2014 at 04:18 AM. Reason: OP complied with moderation request.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

    My apologies. I have fixed the post as requested. Thanks for the heads up.

  4. #4
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

    Hi there,
    Your issue is in only one row of Your code.

    Before:
    Please Login or Register  to view this content.
    and it should be like this:
    Please Login or Register  to view this content.
    Try

    Regards

    M

  5. #5
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

    Thanks for the help that solution works great!

  6. #6
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Need to Build Macro that Pulls Data from one Worksheet into a Second Worksheet

    You are welcome!

    (Donīt forget to add reputation if my solution was helpful)
    Regards
    Miroslav R.

    (If You like my solutions, feel free to add reputation.)

+ 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. Replies: 0
    Last Post: 07-01-2013, 10:19 AM
  2. [SOLVED] Summary Worksheet that pulls data based on a date match
    By reyaingle in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-12-2013, 12:33 PM
  3. [SOLVED] Editing worksheet which pulls data from another worksheet
    By src16 in forum Excel General
    Replies: 18
    Last Post: 02-01-2013, 06:12 PM
  4. Writing a macro that pulls data from a specific worksheet
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2008, 05:21 PM
  5. [SOLVED] How do I conditionally build worksheet from existing worksheet?
    By Bob G in forum Excel General
    Replies: 1
    Last Post: 07-03-2005, 02:05 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