Forum Discussion
Dexlee46
Dec 16, 2019Brass Contributor
Creating a Macro to shift data from word to excel
Hello, 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 purc...
mathetes
Dec 16, 2019Gold Contributor
I don't have a direct answer to your request. Rather a question: is it necessary for some reason that the originating Purchase Order has to be in Word? There are Excel Forms that could serve the purpose also (I think).
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.
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.