Hi

Got a bit of a complicated prob.....reguarly at work we transfer data from
one program to another. We have a 'matrix' to translate the data from one
format to another. Every week I have to update the matrix by running a
spreadsheet from the system and manually converting it into the other format
and then load it up ready for when we do the transfer. If I'm in a hurry or
whatever, mistakes are made in the matrix and it makes HUGE muckups in our
other system.

I'm looking at a way to automate it to counteract these human errors, but
its becoming a bit of an impossible task!! All the codes from one system are
in different formats and it requires me to know how they are translated,
trying to create a formula or whatever todo this is hard! There are never
any exact number of codes for each set each week, there can be none, so how
do I get excel to realise this?

I think Im going to have to use some VB todo this which I know almost zilch
of at the moment. Realise this is a long term problem so am willing to learn
it and see if I can solve it, but that takes time!

If anyone wants the challenge of trying to help me out, please email me and
I will send you the sample files so you can see what I'm going on about!!

Thx in advance

Andy