Searching for a specific value on another sheet and returning the row number.

Ok, this may be more simple than I am making it out to be. I need to take a name from one sheet and search for it on another sheet. I need the row number to add into a formula. This wont make much sense until you actually open the sheet and look at the buttons and the macros assigned to them.

I need the AddVisit button on the Payment Sheet to take the name from A2, go to the A-M sheet, find the name there, take the row number of its location as a variable and plug it into this formula:

Please Login or Register  to view this content.

Anything that has a defined row number will use the variable. I need this, because I need to have multiple payment sheets and this document will be updated daily. I dont want to have to change the values every time I sort the information. I also dont want to create a macro for each payment page. I have a multipurpose button on the page already. Sorry for the long winded explanation.

-Cheers

Please Login or Register  to view this content.

That, sir, worked wonderfully. I knew I was making it hard on myself. I guess I was just looking at it for too long. lol!

Thank you!

-Cheers

@ Ataraxicatom

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.