• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 86
  • Last Modified:

Excel 2013

I was given a 2013 excel spreadsheet with different kinds of equipment listed. I would like to create different work sheets in the same work book to separate the different types of equipment. I have three different types of equipment. Is there a way to select certain rows and move them to different worksheets without doing it manually?
4 Solutions
Convert the data into a table - it would them make selecting the cells easier. Want to post an example?
ShumsDistinguished Expert - 2017Commented:
Without seeing your sample, it would be difficult to provide you VBA code, below link may help you get started:
NorieVBA ExpertCommented:
There are all sorts of ways to do this type of thing, really depends on what you mean by 'manually'.

Do you mean row by row?
Rob HensonFinance AnalystCommented:
If you apply an AutoFilter to your list you can then filter the columns based on the equipment type.

When a filter is in place you can select the visible cells as a block and copy them. This will only copy the visible cells and when pasted into a new sheet will paste as a block without the hidden data.

As you only have three types, it would involve applying the filter and copying only 3 times.
Rob HensonFinance AnalystCommented:
Alternatively, you can make use of a feature of Pivot Tables.

Select your data and create a pivot table from it. Use your Equipment type as a Row header and any other field as a value field to create a count or sum. You will now have a Pivot Table with three data rows. If you double click on the Data Value (the count or sum) it will create a separate sheet with the items from the original that make up that value. Do that for each of the 3 item counts and you will get the three sheets with lists of each equipment type.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now