Previous Topic Next Topic

Excel - sort by column specifics, copy rows to new worksheet

Closed
beccalouwho - Mar 24, 2014 at 10:59 PM
 beccalouwho - Mar 25, 2014 at 11:15 AM
Hello,

I follow directions very well, but I just don't know enough about Excel to create what I am wanting.

I've created a workbook of our office's PC inventory. I would love to sort that even further by creating separate worksheets by OS. (I have a column that tracks which OS is on the PC.) For example: Column F has either XP or Win7Pro as the OS used. I would like to be able to take that information and sort it into two separate worksheets (One for each). - keeping the rest of the data I have put into the rows. (which has user name, model number, service tag.... etc.)

Any assistance would be so greatly appreciated!! Thanks!



2 replies

Answer 1 / 2
Derek32
Posts
2
Registration date
Tuesday March 25, 2014
Status
Member
Last seen
March 25, 2014
 1
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
1
Answer 2 / 2
beccalouwho
Mar 25, 2014 at 11:15 AM
Thank you!! That was so easy! I can't believe I forgot filter... :)
0