Forum Discussion
Solved
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 ...
Perhaps like this?
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?