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.

chemnks Wrote:
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.


Do your headings run down the rows or accross the columns?


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516682

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.