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? |
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 |
All times are GMT +1. The time now is 04:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com