adamscourfield
New Member
- Joined
- Nov 28, 2019
- Messages
- 7
- Office Version
- 2010
- Platform
- MacOS
Hi all,
I am stuck on a problem. I have need to insert a vba macro into a sheet for my admin team. I want to find the highest value from a range in one sheet and return the value to another sheet if the adjacent column matches. I also want it to return it to the next blank cell in that row. So...the highest score for Name 1 in sheet 2 would go into the next black row in column B for that name. Any help would be greatly appreciated.
Sheet 1
A B
Name 1. SCORE
Name 2. SCORE
Name 3. SCORE
Name 4. SCORE
Sheet 2
A B
Name 1. 1
Name 1. 10
Name 1. 8
Name 2. 7
Name 2. 6
Name 3. 5
Name 3. 4
I am stuck on a problem. I have need to insert a vba macro into a sheet for my admin team. I want to find the highest value from a range in one sheet and return the value to another sheet if the adjacent column matches. I also want it to return it to the next blank cell in that row. So...the highest score for Name 1 in sheet 2 would go into the next black row in column B for that name. Any help would be greatly appreciated.
Sheet 1
A B
Name 1. SCORE
Name 2. SCORE
Name 3. SCORE
Name 4. SCORE
Sheet 2
A B
Name 1. 1
Name 1. 10
Name 1. 8
Name 2. 7
Name 2. 6
Name 3. 5
Name 3. 4