Hello all I am hoping someone will know what I am trying to ask here. I am sure its gonna be a IF THEN or ELSE but cant figure out the formula to do it.
I have a doc with multiple worksheets i.e. W1 & W1 NC, W2 & W2 NC. I want to make it so W1 NC pulls all text from W1 a12:f12 if n12=No Calls. And can it do this and skip the lines on W1 NC that are not No Calls? What is the formula I would use to make this possible?
Thanks in advance
Bookmarks