Here is a solution: http://cjoint.com/?cAt7oIQXiu

HIH

--
AP

"chemnks" a écrit dans le message de
...

Dear Sir,

1st Sheet

I have 100 records of different items having details (code no, name, size,
type, Amt. etc.) per row from A5...A105


2nd Sheet

I Want to check a lot number in cell A1 such as (1 for 1st 10 records, 2
for
next 10 records, 3.....etc)

By typing the lot no in cell A1 the display area should check it and
display
correcponding 10 records from 1st sheet.

Note: Display area for 10 records are same for every 10 records.


Please suggest

Yours Faithfully
NKs.