I would like to enquire. I am using Microsoft Excel 2007.
I have a excel file database probably 5000 rows. It consists of lots of rows and columns. I have attributes like Product Code, Product Description, Price, Qty and so on.
Is there a way to pull out just a few rows i want? For example, I only want to view Product Code #1, #178, #789, #1987 only.
Perfect Scenario: For example, i key in #1, #178, #789, #1987 all in separate cell, it will auto show me the correspnding Product Description, Price, Qty and so on.