| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Excell table from contects of another
I have an existing table with multiple entries (say 200). each has a status
code "1" or "2". how do I code a function (or something) that will allow the second table to automaticaly populate its entries from the first table and contain only the records (say 15) with a status code of "1". Where 2nd table will now only be 15 rows long with no blank rows in between. Using Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do pivot table source fields automatically create tabs | Excel Worksheet Functions | |||
| create pivot table with master/detail data from 2 worksheets | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
| How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Linear Mode
