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.
Bookmarks