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?
InSearchOfAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

stevericeCommented:
Convert the data into a table - it would them make selecting the cells easier. Want to post an example?
0
ShumsExcel & VBA ExpertCommented:
Without seeing your sample, it would be difficult to provide you VBA code, below link may help you get started:
EXCEL VBA : FILTERING AND COPY PASTING TO NEW SHEET
0
NorieAnalyst Assistant Commented:
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?
0
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.
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.