Software

Ask something
Question Locked

Is there an Excel formula that will separate data into multiple tabs?

0 helpful
2 replies

by shellyrocks21

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here's my problem. I have a very large Excel document and I need to put all of the rows for each different office into its own tab. The problem is that there will then be 62 tabs. I don't really want to have to copy and paste manually. Is there a way (a formula or some sort of filter) to tell Excel to move everything with a certain criteria in a certain column to a new tab?

Thanks!

2 replies

by Former member

"Show Pages" command can be found under the DATA category -
just drag it to any of your toolbars. Click on your page field header in the pivot table, then the "show page" button - you will automatically get separate tabs for your page field subjects.

The functionality exists for Page Fields not Column Fields.

If you have a Page field set up, then from the PT Toolbar dropdown, select
Show Pages.
This will create a new tab in the workbook with all of the data relating to each of the Page fields.
More info here:
http://articles.techrepublic.com.com/5100-10878_11-5499381.html

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.

This discussion is closed to new replies.