Changing report formats

[Karimb]

Hello everybody.

I work at pharmaceuticals company, and receive tons of sales reports in
different formats. In order to store them into our MS Access database, I have
to transform all reports into our format. I wanted to know if there is any
way to automatically change those reports into our format? External software
of add-on etc.?

Thank you for your help.

 

[Pete_UK]

You could devise a number of "translators" to convert a particular
supplier's format to suit your own. Basically, you would copy the
source file into a "source" sheet and formulae can convert that into
the format you require on another sheet. A simple macro could automate
the process for you.

Hope this helps.

Pete