Yes I was afraid of that.

The client doesn't use access so I was trying to keep everything on excel.

However, can I set an automated process like a macro to perform this task
through access and still end up with a csv file?

I use access & excel but always seperatly so I don't know if they can
interact with each other in a suitable way for this task.

"ERR229" wrote:

> Hi Chris,
>
> It looks as though you're trying to use Excel as a relational database and
> it's not designed for that. Do you have Access by any chance? That would
> really be the way to go.
> --
> ERR229
>
>
> "Chris" wrote:
>
> > Hi,
> >
> > I am trying to convert the payroll data I receive from my clients into a csv
> > file that I import in to my payroll program. Ideally I would like it to be
> > all automatic (marco).
> >
> > The problem lies in the variable nature of the information I receive.
> >
> >
> > Here is the basic layout:
> >
> > NAME | ID | Basic pay | Commission | Overtime
> >
> > Bob 2 500 300 50
> > James 3 400 20
> > Sarah 4 500
> > And so forth
> >
> > THe layout I am trying to achieve is the following:
> >
> > Bob 2 Basic pay 500
> > Bob 2 Commission 300
> > Bob 2 Overtime 50
> > James 3 Basic pay 400
> > James 3 Overtime 40
> > sarah 4 basic pay 500
> > ...
> > I can transpose the detail & amount easily but how can I get excel to
> > automatically match the name and ID number for each field. As you can see Bob
> > has 3 entries ,James has 2 and sarah only one. The number of employees varies
> > every month and their payroll details also.
> >
> > Any help would be great.
> >
> > Thank You