Suppose I have some data and an if function in Column A. The If function
returns a "Yes" if 4 sets of criteria are met. If on another tab I want to
import all data with Yes in the A column into the new tab and I do not want
spaces between rows.

For example, in column A says if(and(D1=1, E2=1, F3=1, G4=1),"YES","") and I
want the other tab to dispay all the information from columns B, C, D, E, F &
G. Can this be done? Thanks in advance