Go to another worksheet and then come back to the original

I'm setting up a payroll for several employees in one workbook. I start from the particular employee's worksheet and then I need to go to another sheet where various information is stored and then come back to the original employee's sheet. The current macro works fine if the various information is stored on each employee's worksheet but I can't figure out how to go to another sheet and then come back to my active cell in employee sheet.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

I appreciate your effort but that didn't work. Somehow, the macro doesn't like for me to go to another page to make my selection.

Perhaps I need a totally different approach to my problem. Here's my situation. The payroll that I am trying to fix is for a trucking company. We have some hauls that the pay is figured on a per mile basis. Then we have some that are paid on a per load basis. There are several hauls on the per load basis that have various origin points and various destination points. For instance, I have origin points A, B and C and destinations X, Y and Z. I have a list that designates hauls of A-Z, B-Z, C-Y and pay is determined by the combination. There is no way to have a mathematical formula that determines the rates for the various combinations. It's simply going to be a list. I'm trying to avoid putting this list of pre-determined on the same sheet as each individual employee. The concern is future changes by folks that may not have a decent grasp of Excel. My thinking is, if I have the haul rates on one protected sheet, future changes to haul rates would be a simple modification to one sheet as opposed to making changes to each sheet.

If any of you folks have a different procedural idea on how this could be accomplished, I'm all ears.

That is where I would have all of the information for the loads stored. I can put the information for these loads on each individual employee's sheet but if I do, I am concerned about future changes. In other words, let's say that a new load comes along that is D-X and employee John Doe hauls that load. That D-X load gets put on John Doe's sheet but D-X doesn't get put on all of the other employee's individual sheets. I need all changes to be on sheet that can be selected from any of the other employee's sheets.

I'm not sure I understand how I could get the information from the other sheet without selecting(going to) the other sheet.

But yes, I am just going to the other sheet to get data.

It is named "Spare"

This is my current sheet.

And yes, the user would select let's say, CC-PB under the Chips column. Then the macro would copy the information to the right of the CC-PB and bring it back to the "New Driver" tab and proceed with the rest of the macro.

I get a
Run Time Error 1004
Select method of Range Class failed.

When I click debug, it goes to

userResponse.Select

WOW! I believe that is going to work fine. I certainly hope that you understand that my clicking "Add Reputation" for you is not even a fraction of the appreciation that I have for the help that you have given me.

Be blessed today!