how do i use the function to copy and paste a determined variable.
Example I want to move all the rows that have a #1 in the first column to a
new work sheet and #2 and so on. I can use this function =IF('Email
Leads'!A2=1,1,"") and =IF('Email Leads'!A2=1,'Email Leads'!B2,"") but that
looks for a certain cell. If I have over 25 cells to look from, what is the
function to use? Thanks
1 Bound Tree
1 Bound Tree
2 ICOM
2 ICOM
2 ICOM
3 Skedco Inc
3 Skedco Inc
|