Eawyne
New Member
- Joined
- Jun 28, 2021
- Messages
- 43
- Office Version
- 2013
- Platform
- Windows
Hi all =)
my needs could be summarized this way : when I write an ID in a cell from Row 2 in Sheet1, it should check the content of Row1 from Sheet2 => if there is a match (ie. A3), then the content of the adjacent matching cell (B3) from Sheet2 should be displayed in a Msgbox.
This can be linked to this thread ; the main problem is the same : I'm able to identify some solutions but none answers the precise options I'd want (display a result in the msgbox, for example) and I can't find a way to merge the various bits of code
I've looked up several queries, going on threads like this or even this here, but I truly do lack the bascis to tie it all together, which is frustrating as I technically have the start from my previous thread !
Any help is welcome
my needs could be summarized this way : when I write an ID in a cell from Row 2 in Sheet1, it should check the content of Row1 from Sheet2 => if there is a match (ie. A3), then the content of the adjacent matching cell (B3) from Sheet2 should be displayed in a Msgbox.
This can be linked to this thread ; the main problem is the same : I'm able to identify some solutions but none answers the precise options I'd want (display a result in the msgbox, for example) and I can't find a way to merge the various bits of code
I've looked up several queries, going on threads like this or even this here, but I truly do lack the bascis to tie it all together, which is frustrating as I technically have the start from my previous thread !
Any help is welcome