find specific text in column A then column B is false

[Saoirse]

I am trying to write a VBA to look at worksheet A column A for a Specific name then have the cell in worksheet B reflect what is in Worksheet A column B based on column A's value. The issue is that I cannot know which cell the name will be in. So the name Albert will be somewhere in worksheet A range A1:A11000.
For example: Worksheet A
Albert 16
Ben 22
Collin 5

Worksheet B
Will post value of column B from worksheet A into column AB on Worksheet B.

 

[Joe4]

Why do you need VBA?
Couldn't you just use a VLOOKUP formula to do this?

VLOOKUP Function

The Excel VLOOKUP function is used to retrieve information from a table using a lookup value. The lookup values must appear in the first column of the table, and the information to retrieve is specified by column number. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for...

exceljet.net

 

[Saoirse]

Vlookup doesn't work because I need to find an employee number out of 30 employees. i can't just put in a specific cell to match it up to.

Also, I need a VBA since the report I am pulling the info from changes daily and I need it to only run once when I update the report to my tracker.

So I am trying to find a way to add onto my current VBA for this specific data.

 

[Joe4]

I am not convinced that you cannot use VLOOKUP.
Are you familair with this function? Do you understand how it works?

Maybe it will not work in your case because of the structure of your employee data, but you have not shown us what that looks like, so we really cannot make that determination.
Can you post a small sample of your employee data so we can see how it is structured?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Saoirse]

I will post images, I have to get to a different computer, this one doesn't work. I'll send this evening. For now, I will say that I am pretty new to Excel and am learning as I go. But when trying to do a VLOOKUP, the formula is =VLOOKUP((cell number) but there isn't a specific cell number i can put in there. I need to enter in a person's name. Can I do that? I only see the ability to enter a specific cell.