Find and print in new sheet
I want to make an function that looks for an number in one worksheet and copy
it in a new worksheet. like IF(A1=2;"testing";"0") but i dont want it to
write 0 or leave the line empty and jump down,
For exampel if a1= 1 then write b1 and d1
If a2=2 dont write anything but find next 1 and write that on next row in
new worksheet.
|