| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display 10 records from same workbook but from different sheet
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy sheet - Break Links to Old Workbook - Retain Formula. | Setting up and Configuration of Excel | |||
| Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
| Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Threaded Mode
