View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SajberSmurf SajberSmurf is offline
external usenet poster
 
Posts: 1
Default 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.