transferring sales orders created in word over to excel

K

Klann Tools

Hello,
My company have been raising our sales orders manually in word over the last
2 years and now the time has come to transfer it all to a sage system. Our
sage consultants advise that they can export all data to Sage as long as it
is in a CSV format - which means using excel.

Our sales orders have a header table section giving delivery address etc
followed by a number of lines in another table detailing what the customer
has ordered and what price they paid etc.

We have over 2000 of these word documents that need putting into a csv
format. Does anyone have any suggestions about any quicker, easier methods
of doing so than manually transfering all the data from word into excel, as
that would take hours!

I did wonder about the use of macros to get the address header table into
excel but I wondered how you used macros and got them to automatically start
on the next line after completing the first line.

If theres anyone out there that can help do let me know!
 
J

Jezebel

Easy enought to do with a macro. Given the quantity to be done, and the
(presumed) value of the data, pay someone to do it. It's a couple of days
work all up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top