View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edmond Edmond is offline
external usenet poster
 
Posts: 1
Default How to find a data in Sheet1,automatic transfer to Sheet2(Excel)

Pls in a specified box of Sheet 2, I want to capture a data in Sheet 1. This
data need to fulfill two condition. For example, if the name is equal to
"Paul" and the age is equal to 30, then this box of data will be captured by
a specified box of Sheet 2. .Pls help to solve and advise the formula.

Thx a lot in advance.

Edmond