Related:
- Excel - sort by column specifics, copy rows to new worksheet
- Excel vba sort by column number ✓ - Forum - Excel
- Excel create unique id for each row ✓ - Forum - Excel
- Excel vba copy rows to another worksheet based on criteria ✓ - Forum - Excel
- Excel sum of column if another column equals ✓ - Forum - Excel
- Excel match two columns and output third ✓ - Forum - Excel
2 replies
Derek32
Mar 25, 2014 at 04:23 AM
- Posts
- 2
- Registration date
- Tuesday March 25, 2014
- Status
- Member
- Last seen
- March 25, 2014
Mar 25, 2014 at 04:23 AM
1. Filter the title row, click on the filter button, check the boxes of the items you want to show in your table, say XP. You'll got information which is related to XP only.
This tutorial shows you how to filter data.
https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e?ocmsassetid=ha102840028&ctt=1&correlationid=f37f57e3-91ca-40e9-a823-62ac8feee447&ui=en-us&rs=en-us&ad=us
2. Select the filtered data, copy visible cells only, then you can paste all the filtered information to a new worksheet. You'll got XP information in new sheet.
https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e?ocmsassetid=ha010244897&correlationid=49859582-5f61-4080-9cf9-78a9f36ea19c&ui=en-us&rs=en-us&ad=us
This tutorial shows you how to filter data.
https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e?ocmsassetid=ha102840028&ctt=1&correlationid=f37f57e3-91ca-40e9-a823-62ac8feee447&ui=en-us&rs=en-us&ad=us
2. Select the filtered data, copy visible cells only, then you can paste all the filtered information to a new worksheet. You'll got XP information in new sheet.
https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e?ocmsassetid=ha010244897&correlationid=49859582-5f61-4080-9cf9-78a9f36ea19c&ui=en-us&rs=en-us&ad=us