Hi
Im a VBA novice so please take it easy on me. I know of it and think I can
get it to work but it isnt taken for granted that I can. I have lots of
worksheets on one spreadsheet which hold financial data like this:

Worksheet for April 2006
Code Amount
abc1 20000
ght23 3626

There is a different worksheet for each month, totalling 8 or 9. What I
need is one worksheet which shows the data like this:

Code April May Jun Jul
Aug
abc 1 20000 365 0 0
4545
ght23 3626 656 5 0
0

Each code wont appear in every worksheet, this is where the zero above would
be needed. Does anyone know of any possible way to do this or do I need to
use something like IDEA? If I can clarify in any way please let me know.