Hi All,
It's more than likely that I'm trying to achieve the impossible; but here is my problem.
I have a supplier who sends me a Word Document which is a Price List with the products priced in their local currency and I need to convert this into my local currency; sounds simple on the face of it but I have several problems
Problems: -
- I need to retain the document format; it contains Headers/Footers, Banners and Graphics and I must not lose these.
- The Exchange Rate is constantly moving, albeit I do have a fixed 90 Day Rate.
- The document contains multiple Tables (1 for each Product).
Currently I am sitting down with a calculator and manually editing each cell, a process which takes several hours to complete. I have been scratching my head for a few days now find some easy solution to this and automate the manipulation of the cell holding the prices. I'll include a screen snip so you can see what I'm up against.
Any feedback would be cool.