Hi,
I'm new to this and just can't seem to work out how to do this. I am trying to write a function that searches through G7 to G17 in Sheet2, and if it finds a certain color (13421823) in a cell, for example G10, then it automatically puts the value of A10 (an employee) in a different cell (for example B4) in a different sheet (Sheet3).
Thank you so much in advance!!
Bookmarks