12-16-2019 12:16 PM
12-16-2019 12:16 PM
Would anyone know how to assemble code to create a macro to shift data from word to excel.
So I attached the purchase order word document, and PO log spreadsheet. The part of the purchase order that would need to be populated is the purchase order number, supplier, item number, part number, description, revision number, quantity, date required, and unit cost (extended cost is automatically calculated), this information will go from the word document, to the excel spreadsheet in the appropriate cells.
Again, all I need is information the purchase order document specified above, to be transferred to excel, by way of a button, or something more efficient.
12-16-2019 01:46 PM
12-17-2019 09:07 AM
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.
12-17-2019 10:12 AM - edited 12-17-2019 10:20 AM
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.
12-18-2019 07:25 AM
We are currently undergoing a ERP implementation. I was just looking for quick fix, as the system will not be implemented fully until sometime next year.
Thank you for the input.
12-19-2019 12:04 PM
@Dexlee46 if your doc contains bookmarks, you should be able to search for those and copy/paste with vba. Or something like this: https://stackoverflow.com/questions/3567441/extract-data-from-word-document-to-an-excel-spreadsheet