Display 10 records from same workbook but from different sheet

C

chemnks

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.
 
D

davesexcel

chemnks said:
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.
Click to expand...


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