| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Paste a sub-table from a larger table
I need to paste a selection of data from a larger table on another worksheet,
subject to preset requirements. I know how to select the required data field, but I don't know if there is a way to paste this data onto a new worksheet in its sub-table form? |
|
#2
|
|||
|
|||
|
You can use an Advanced Filter to extract data from a table. There are
instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html GrantM wrote: I need to paste a selection of data from a larger table on another worksheet, subject to preset requirements. I know how to select the required data field, but I don't know if there is a way to paste this data onto a new worksheet in its sub-table form? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Linear Mode
