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" <(E-Mail Removed)> a écrit dans le message de
news:A47D8781-D6B1-42A1-8D5A-(E-Mail Removed)...
>
> 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.
>
>
>
>
>
>
>
>
>