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: -

1. I need to retain the document format; it contains Headers/Footers, Banners and Graphics and I must not lose these.
2. The Exchange Rate is constantly moving, albeit I do have a fixed 90 Day Rate.
3. 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.

Attached Images

PList1.JPG (69.1 KB, 15 views)