On Thursday, September 27, 2012 3:52:19 AM UTC-5, aiezzat wrote:
Hi all,

I'm a new member for this forum. The question is: How do i create a link

between a sheet? My idea is, i need to type some specific text in a cell

(such as part no), and then excel will automatically shows the details

of this part(such as size,material,price,supplier and etc.) along a row.

Of course i already key in all the part details in a different sheet.

Thanks in advance..









--

aiezzat

Or use datafilterautofilter macro