Hi all,
I have an protected excel file (sheet1) with approximately 200 data entry
(200 rows and 10 columns). and user can enter the data in sheet1. I would
like to build a second sheet to do advance filter and display selected 5
column only not all but with a criteria cell in the second sheet. Criteria
are 2 or 3.say for example I have a invoice number column with different
invoice numbers. In the second sheet, I have cell A1, a2 and a3 as an input
cell... when I input on of the invoice number and other into cell A1,A2 and
A3 it would filter the 200 data and only display the 10 columns of
information of the invoice number in cell A1. If I change the invoice number
in cell A1, it would change accordingly. Do you think there is a way to build
this in excel?

Example: In Sheet1:=

Invoice No. Date Amt XX YY Shipdt Mode
1 100 01/01/08 50000.00 FF yy 05/01/08 ship
2

In Sheet2 : Which I want

Criteria : Invoice No, Shipdt mode

display column : Invoice No. Amt Shipdt Mode

Thanks in advance.
RKS