Forum Discussion
Creating a Macro to shift data from word to excel
It also would be helpful to know how many people are involved in this procedure: and whether they are part of your organization or are clients...
In general, on behalf of those who ARE able to write VBA code and the like, I think you'd be more apt to get good help if you describe the situation a bit more fully, so that your specific request can be seen in its larger context. This would also enable them to suggest alternative solutions.
Thank you for the insight Mathetes. Unfortunately the purchase order is a controlled document that has always been in word format, and to change to excel would be difficult regulatory wise. The main people involved would be me: I do purchasing and inventory management. My supervisors: They handle the ad hoc supply chain management for our company. And our receiving department: who will receive in orders, and reconcile received amounts from ordered amounts. In that case I may just record a video showing exactly what I mean.
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
