Forum Discussion
Search value in multiple Sheets - Fill adjacent cells when value is found
Perhaps like this?
Sorry for the late reply.
So, in Sheet SL&UR I got a search box in B3, which returns a code in C11. In the example the value is CP42735.
I want to search for the C11 value in Sheets SL_2019, SL_2021 and SL_2022 and in whatever row it is found I want to fill the adjacent rows in Columns L with Today() date, M with "Crew_1" and Q with "Drawn".
In the example the value is found in SL_2019!G13, so the end result would be:
SL_2019!L13=23/5/2022
SL_2019!M13=Crew_1
SL_2019!Q13=Drawn
Hope you can come with up with some of your magic.
See the attached version.
I moved the existing code from the SL&UR worksheet module to a standard module, and created an On Change event procedure for the search box in the worksheet module.
That is wicked!
Unfortunately, this step is going to be the last in my chain work so, this auto-populating event is of no help for me at all...
If you could take the time and restructure it so it works only when I call it, that would be great.
Thank you again for coping with me. I really appreciate it!
Perhaps like this?