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
|