Re: Complicated Formulas

It's a bit of a tall order, expecting someone to jump in and say they'll
help with very little idea of what is required.

If you start with some examples of the sort of data you have and what you
need to "translate" it to, it may give folks an idea what's needed and offer
some suggestions.

--
Ian
--
"Andy (Hypnotic_Monkey_Scratcher)" <Andy
(Hypnotic_Monkey_Scratcher)@discussions.microsoft.com> wrote in message
news:5C581A7C-1CFF-46D7-8F6A-0D7DF8C8B099@xxxxxxxxxxxxxxxx
> 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
> spread*** 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
>
> isitaaaandrew@xxxxxxxxxxx


.

Loading