Hi I am trying to copy data from one sheet to another, but only if one value fits a certain criteria.
I do not want any blanks in the data
example sheet 1:
A B C
1 Jim yes
2 Joe no
3 John yes
4 Jake no
example sheet 2: Only if(c="yes")
A B
1 Jim
2 John
NOT:
A B
1 Jim
2
3 John
4
Thanks in Advance!
Bookmarks