Splitting Rows from a Primary Page in a Notebook into dept specific pages

[AdrianScherer]

I have an Excel Notebook with 8 pages. The first page is a list of all of the doors in our building. Pages 2 - 8 are the same list for each department in the building. On each page, each row (9 cells) is one door. Column G in that row specifies which department the door belongs to using a 1 or 2 alpha character code. What I am trying to do is write formula so that, each door listed on the main page (and when I add a new door to the list), based on the character in column G, the row of 9 cells for that door is automatically added to the appropriate department's page as well. Is that possible? Thanks!!!

[Domski]

Hi,

You'll find this difficult to do with formula. You could use VBA but I'd question why it's necessary at all. Could you not just use AutoFilter to display just the department that you require and then only have one set of data to worry about.

Dom

[AdrianScherer]

Thanks for your quick response. I am not familiar with Autofilter. Sounds like it may work for me. How would I apply it?

[Domski]

Have a look here: http://office.microsoft.com/en-us/ex...010370616.aspx

Dom

[AdrianScherer]

Looks like that will probably work for me. Thanks a bunch!!!