I am an interior designer with a lot of workbooks for different projects, but if possible I would like to streamline them into a master spreadsheet and then be able to select and print out, for example, all the tile selections in the entire house, or also just the selections for one room. Is there any way to do this? To categorize information within multiple categories? Not sure if this is possible in Excel. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Is there a way to categorize information in Excel?
- Thread starter court122
- Start date
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Similar threads
- Question
- Replies
- 2
- Views
- 529
- Question
- Replies
- 2
- Views
- 582
- Question
- Replies
- 3
- Views
- 2K
- Replies
- 6
- Views
- 272
