#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
I don't quite understand what your final design is, but why not use MsWord Mail Merge ? It's built-in and offers a lot of possibilities.
On this forum there are also great Word Gurus like macropod,Ch Kenyon, ... that can help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Construction Punch List using mobile | hhyokki | Office | 1 | 12-08-2020 11:02 PM |
How to generate a clauses document from 10 yes/no selections with some Sub-selections | pgg1507 | Word | 2 | 10-18-2020 03:59 AM |
Creating a letter in Word, with text pulled from an Excel document based on selections in a userform | TMAL | Word VBA | 6 | 12-15-2017 02:16 PM |
Macro to read text file and organize data in excel | srinidhi.mv88 | Excel Programming | 5 | 05-19-2015 12:06 AM |
New heights of construction! | Ulodesk | Chitchat | 0 | 04-27-2015 09:59 AM |