Hi All,

Can anybody help me out with some vba code to create a crosscast
report from a tabular data report. I have a complete mental blank on
this!

This is an example of the soure tabular data:

Number Forename Surname Address Line 1 Address Line 2 County Post Code
Element Amount
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX Gross 4000
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX Ees Tax -1600
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX Ees Ni -200
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX Net Pay 2200
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX Ers Ni -320
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX PAYE 2120
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY Gross 2000
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY Ees Tax -800
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY Ees Ni -100
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY Net Pay 1100
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY Ers Ni -160
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY PAYE 1060

This is how l would like to data to be presented:

Number Forename Surname Adress Line 1 Address Line 2 County Post Code
Gross Ees Tax Ees Ni Net Pay Ers Ni PAYE
1 Michael Smith 55 Heatherside Woking Surrey GU01 1XX 4000 -1600 -200
2200 -320 2120
2 Diana Jones 77 Acacia Avenue Guildford Surrey GU20 7YY
2000 -800 -100 1100 -160 1060

Please beware of the word wrapping, each employee should be on one
row.

All fields are included in the source even if they are blanks or
zero's so that problem can be ignored.

Any help in this would be gratefully appreciated.

Kind regards

Michael