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.

sorry the formatting was a bit buggered, just to clarify I need all codes on
one worksheet with the amount by month shown.

"Khurum" wrote:

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.

One way would be to create a pivot table using the multiple consolidation
ranges option. You would create one page-range for each month. Then in the
layout you would make the row a row field, the page the column field, and the
column the page field. When I do this I get the layout you are asking for.
You may have to play with the format of the pivot table and its fields to
pretty it up.

Hope this helps.

Bill Horton

"Khurum" wrote:

sorry the formatting was a bit buggered, just to clarify I need all codes on
one worksheet with the amount by month shown.

"Khurum" wrote:

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.

Thank you William, that was very clear, and completely worked.

"William Horton" wrote:

One way would be to create a pivot table using the multiple consolidation
ranges option. You would create one page-range for each month. Then in the
layout you would make the row a row field, the page the column field, and the
column the page field. When I do this I get the layout you are asking for.
You may have to play with the format of the pivot table and its fields to
pretty it up.

Hope this helps.

Bill Horton

"Khurum" wrote:

sorry the formatting was a bit buggered, just to clarify I need all codes on
one worksheet with the amount by month shown.

"Khurum" wrote:

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.