Forum Discussion
Search value in multiple Sheets - Fill adjacent cells when value is found
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.
Perhaps like this?
9 Replies
- JoAvgBrass Contributor
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.
- JoAvgBrass Contributor
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!