Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2023, 02:15 PM
SSatterwhite SSatterwhite is offline Automating Template Workbook: Breaking Up Material Table into 3 Different Tables Windows XP Automating Template Workbook: Breaking Up Material Table into 3 Different Tables Office 2021
Novice
Automating Template Workbook: Breaking Up Material Table into 3 Different Tables
 
Join Date: Apr 2023
Posts: 1
SSatterwhite is on a distinguished road
Default Automating Template Workbook: Breaking Up Material Table into 3 Different Tables

Hi, I have attached a workbook that I would like to automate as much as possible but am not familiar enough with VBA to do so.

The "EquipmentList" tab is sent to us by our vendors when we request a quote and is not changed by us. As you can see it is a single list where the headers are repeated throughout as the type of equipment is changed (Pipe,Elbows,Tees,etc.) this list changes with each project so having a macro that could recognize when moving from a new type would be ideal.

In the comments section, this is a confirmation that the Manufacturer listed is one of the approved manufacturers in the "Manufacturers" tab. There are exceptions to this so one not being approved doesn't kill the project they just need approval so highlighting those that aren't approved in that list would be ideal. There are so many manufacturers that a formula gets too tedious to write (I've tried).



The three remaining tabs "Pipe", "Valves", "Fittings" are created from the "EquipmentList" tab. These take columns A and D are combined using the CONCATENATE function and a column assigning a control # (P-pipe, V-valve, F-fitting) and a second column to manually input a serial #. Pipe in the Equipment list correlates to the "Pipe" tab, Valves to the "Valve" tab and EVERYTHING ELSE to the "Fittings" tab. I have been able to accomplish a rough version of this simply using formulas but for the fittings it gets ugly. There are examples of what the final product should look like.

Again the idea would be to automate as much as possible to avoid human error which occurs regularly, currently nothing is connected and each user uses their own discretion. If anyone can help especially with the fittings portion this would be amazing! Have a nice day!
Attached Files
File Type: zip ForumWBComplete.zip (461.5 KB, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating Template Workbook: Breaking Up Material Table into 3 Different Tables Table breaking across pages even though it's set not to seanspotatobusiness Word Tables 8 07-24-2018 04:52 AM
Automating Template Workbook: Breaking Up Material Table into 3 Different Tables Conversion of Columnwise Bill of Material into Rowwise Bill of Material using Excel Macro VBA mpapreja Excel Programming 4 05-21-2018 05:35 AM
Automating Template Workbook: Breaking Up Material Table into 3 Different Tables Table is page breaking where it doesn't need to jthomas666 Word Tables 4 07-04-2017 10:52 PM
tables breaking accross pages DimBulb Word Tables 2 06-29-2017 09:43 AM
Automating Template Workbook: Breaking Up Material Table into 3 Different Tables Including of the word pages or tables on choice (Automating a quote) 00hepar00 Word 1 01-02-2014 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:25 AM.


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