View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
cdcam cdcam is offline
external usenet poster
 
Posts: 13
Default Formula to copy multiple cells onto another sheet

I have a worksheet containing names and address that are repeated onto other
sheets based on criteria in another column. What formula if any can I use to
determine if that person meets that certain criteria to automatically copy
the 3 columns that the name, phone, and address are located in to another
sheet?