Excel - Organize Construction Selections List By Room
Hi,
I am a contractor and on every job, my clients have to chose their Selections (plumbing fixtures, electrical fixtures, etc.) We track these on a spreadsheet (see attached). We use a table with a column for the selections information, the room it goes in and the category of product (plumbing, flooring, etc.). I like to give my subs just the list that pertains to them and then I like to give my clients a list by room. So I have a need for a report organized by room, then a report organized by category.
Currently, we simply filter the big list by then and print it out, but I don't like the way it looks. I'm trying to find a way to organize it by category on another tab, not show the category column, but place the category above all the data.
I'd prefer to do it through VBA so it's a bit challenging to break it.
Any suggestions would be appreciated. Or if you have an idea for a different organization, I'd love to hear that as well.
|