| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows to Named Sheets
Hello from Steved
I've a summary sheet called Starttrip, In Col A I've got names "Peter", "Stan", "Maranda", "Stewart", "Carol". I've got sheets named "Peter", "Stan", "Maranda", "Stewart", "Carol". =IF(Summary!A6="Peter", ROW(),"") This is in Sheet named "Peter" What is required in the formula below to reconize "Peter" please, or what is required . =IF(ISNUMBER(SMALL(IF($B$2:$B$106="","",ROW($B$2:$ B$106)),ROW(1:1))),INDIRECT("Starttrip!"&CHAR(COLU MN()+64)&SMALL(IF($B$2:$B$106="","",ROW($B$2:$B$10 6)),ROW(1:1))),"") Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you insert rows into multiple sheets in a workbook? | Excel Discussion (Misc queries) | |||
| (Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Exact rows, multiple sheets | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Threaded Mode
