Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2021, 06:55 AM
skoz55 skoz55 is offline Excel - Organize Construction Selections List By Room Windows 7 64bit Excel - Organize Construction Selections List By Room Office 2010 64bit
Novice
Excel - Organize Construction Selections List By Room
 
Join Date: Jan 2009
Posts: 20
skoz55 is on a distinguished road
Default 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.
Attached Files
File Type: xlsm Roush_Selections Workbook_r2.xlsm (127.2 KB, 16 views)
Reply With Quote
  #2  
Old 07-06-2021, 12:03 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel - Organize Construction Selections List By Room Windows 7 64bit Excel - Organize Construction Selections List By Room Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Organize Construction Selections List By Room 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
Excel - Organize Construction Selections List By Room 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
Excel - Organize Construction Selections List By Room 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft