I've looked and can't see if theres a way that you could automate a search so
that it would change a cell reference.
I have a large sheet of thousand of customer ref. no. what I want to do is
create a reference cell or tool that I can type the ref. number into and it
would then add value in to the ref no. row so this could then be filtered to
show who had replied and who hasn't.
Doing a ctrl f and manually adding data is taking too long!
Thanks for looking