Hi everyone! I work for a steel fabrication company that produces numerous parts and utilizes numerous processes. I have a document that our quoters use that has two columns that show the steps in the process involved for that part. I need to be able to automatically sort two columns on sheet 1 and then place that information into a separate sheet 2 that then puts it into a flowchart style format similar to the SmartArt Vertical process. But it needs to update automatically whenever a column on sheet 1 changes.I can't change the source tab but I can make any changes I want to the other sheet. I have an example document we can use as the original has way to many confidential tabs in it. Any help will be greatly appreciated as I am new to VBA/Macros. [ATTACH]n1215064[/ATTACH]
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.