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