Display 10 records from same workbook but from different sheet

[Guest]

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.

 

[davesexcel]

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?

 

[Ardus Petus]

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

HIH