Forum Discussion
Creating a Macro to shift data from word to excel
The situation you describe (especially given the sample documents you've provided) tell me that anything like this in Word/Excel is way above my level of expertise with these tools. There may be others here in this Forum who can help; but the scope of what you've described is well beyond most applications suitable for Microsoft Office suite.
In fact, if I may speak frankly (as one who worked as Director of a major corporation's Hr and Payroll database) I think that what you have warrants a solution tailored for supply chain management. Word and Excel are wonderful programs, and they may have served you well when your company was smaller, but there are practical limits.
If I were you, I'd be recommending that you implement a Request for Proposal (or whatever procedure you all use) from major suppliers of supply chain software. Here are several links to get you started.
- https://www.capterra.com/sem-compare/supply-chain-management-software?gclid=CjwKCAiAluLvBRASEiwAAbX3Gbz7NZz7LTWJUeha-7kxxvJt0Lrl52o8GynA1e0vsamDtN8hxnZ-CxoC7JMQAvD_BwE
- https://pmo.selecthub.com/scm-pricing-report/?campaignid=973759891&adgroupid=51015318911&creative=322778496693&keyword=supply%20chain%20software%20companies&gclid=CjwKCAiAluLvBRASEiwAAbX3Ga2nh5_9zcg4gqoMUthPjGHeGptt1E8TE6_PKJPWjqfsRLE5U5SfIRoCjQQQAvD_BwE
- https://www.supplychaindigital.com/technology/top-10-supply-chain-management-software-companies
