May 19 2022 12:46 PM
Hi everyone.
In Sheet1!C11 I have a value X.
In Sheet 2 Table1, in Sheet 3 Table2 and in Sheet4 Table3.
Value X will appear only once in all of three Tables, in Column G.
I am in need of a macro that performs the following:
Search value X from cell Sheet1!C11 in all three sheets and when, for example, found in Sheet2!G25
1. Fill today's date in Sheet2!K25
2. Fill the word User1 in Sheet2!L25
3. Fill the word Cond1 in Sheet2!M25
Any help would be greatly appreciated.
May 20 2022 02:52 AM
May 20 2022 03:15 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
May 20 2022 11:49 AM
Made a dummy file keeping all the functions without the sensitive data.
Hope I shared it the right way..
https://1drv.ms/x/s!AvoleB1tsIJ8l2FgXbp1vjqpCcp3?e=s7jhvm
Will be waiting for your response.
Thank you!
May 20 2022 12:56 PM
Thanks, I have downloaded the workbook.
Can you now explain what you want using the sheet names and ranges of the dummy workbook?
May 22 2022 11:01 PM
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.
May 23 2022 04:20 AM
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.
May 23 2022 10:13 PM
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!
May 24 2022 03:59 AM
SolutionPerhaps like this?
May 24 2022 04:37 AM
May 24 2022 03:59 AM
Solution