consolidation 1

[thelos]

hi there again

i am writing a macro in which i need to consolidate colums a colums b and colums c (a = WE , b=A type , C =Hours )
the problem is the macro needs to consolidate different depths of information every time ive tried a number of different things none seem to work.
please help

 

[xlbo]

easiest bet for consolidation is a pivot table

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[thelos]

is there any way to code the consolidation?? without using a pivot table??
the reason is the info from my consolidation is picked up from an external graph page which reads in 3 other pages and produces a graph of actual, predicted and also produces an s curve can i still easily link this if i pivot??

 

[xlbo]

give us an example of your data layout and how you want to see the result and we might be able to give you an answer......

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[thelos]

column a column b column c
WE A type Hours
1 dd/mm/yy Pedd 1
2 dd/mm/yy Pedd 2
3 dd/mm/yy Pedd 3
4 dd/mm/yy Pedd 4
5 dd/mm/yy Pedd 5
6 dd/mm/yy Pedd 6

this is how my un consolidated info appears i need code that will aways choose these three rows and will always go to the deepest depth the only thing that changes is the name of my "A type" this time ive shown "Pedd" next time it will be "pest" and so on

any help you can give me would be fantastic

 

[thelos]

the info from the consolidation i just need placed in columns e-g


thanks

 

[xlbo]

Pivottable is defo your best bet

Just follow the wizard

WE & Type as ROW fields
SUM of HOURS as value field



Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[thelos]

thanks guys im off to follow the wizard

 

[xlbo]

Just post back if you have any difficulties with it

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question