Search between two sheets

[Mr_K]

Hi, this is my first post. I've been looking through the forum and have found some similar instances of this question but none really seem to be quite the same. Currently I'm using Pascal coding in the form of an EXE to sort through two sheets in a work book. The procedure is fairly simple:

Sheet 1 has a Customer's Last name and the amount they paid:

Name | Blank Cell | Payment

Smith | | $10.99
Johnson | | $ 6.80

Sheet 2 has the Customer's Last name and which State they are from:

Smith | CO
Johnson | NY

What I need to do is have some sort of macro that copies the last name from the first sheet, finds the customer by last name in the second sheet, and places the state in the second sheet into the blank cell in the first one so that it looks like:

Smith | CO | 10.99

I hope this makes sense. Doing this manually is nearly impossible as I'm sorting through about 1,000 of these. Any ideas/suggestions?

Thanks in advance!

[Leith Ross]

Hello Mr_K,

Welcome to the Forum!

Currently I'm using Pascal coding in the form of an EXE to sort through two sheets in a work book.

I am not sure we can help you. This forum is for VBA (Visual Basic for Applications) questions.

[Mr_K]

My bad, I'm looking for some way to internalize the process in excel. I want to use the VBA, macro, something besides an outside program. I wasn't very clear about that. Regards