hello advanced, I am sorry to ask such a simple thing, but my knowledges in
VBA are really poor :(
please help me, if you can with such a problem.
I have an excel sheet with 3 columns. I must run macro , which will prepare
new tables like this :
original :
colA colB colC
-------------------
A x 5
A y 8
B x 11
B y 16
(number of non unique vaules in colA and colB I dont know)

result ought to be a table (looks like champoins league score):
-----------------------------------------------------------------------
A B
x 5 11
y 8 16

Please if possible, mail the answer in , I have no
permanenet econnection.

Thank you very much !

regards

Marian

It looks like you could use a pivottable to do this.

Select your range and do Data|pivottable
follow the wizard until you see a dialog with a Layout button on it.
click that Layout button
drag the colB header to the row field.
drag the colA header to the column Field.
drag the colC header to the data field.
(If it says "count of", double click on it and change it to Sum.)

And finish up.

If you need a macro, you can record one when you do it manually.

Maros wrote:

hello advanced, I am sorry to ask such a simple thing, but my knowledges in
VBA are really poor :(
please help me, if you can with such a problem.
I have an excel sheet with 3 columns. I must run macro , which will prepare
new tables like this :
original :
colA colB colC
-------------------
A x 5
A y 8
B x 11
B y 16
(number of non unique vaules in colA and colB I dont know)

result ought to be a table (looks like champoins league score):
-----------------------------------------------------------------------
A B
x 5 11
y 8 16

Please if possible, mail the answer in , I have no
permanenet econnection.

Thank you very much !

regards

Marian

--

Dave Peterson

Hello dave, thank you for information, please, if you will so kindly, tell me
the last thing : in pivot table I define :
COLA is colums part
COLB is rows part
COLC is a data part of pivot table.
but : in data part I have got not a vaules but the multiplicity of vaule :(
so it means, that my pivot table created looks like :
A B
x 1 1
y 1 1

instead of
A B
x 5 11
y 8 16

some tips ?

thank you




"Dave Peterson" wrote:

It looks like you could use a pivottable to do this.

Maybe it said "count of" instead of "sum of"...

Did you do this step?
....
drag the colC header to the data field.
(If it says "count of", double click on it and change it to Sum.)

Maros wrote:

Hello dave, thank you for information, please, if you will so kindly, tell me
the last thing : in pivot table I define :
COLA is colums part
COLB is rows part
COLC is a data part of pivot table.
but : in data part I have got not a vaules but the multiplicity of vaule :(
so it means, that my pivot table created looks like :
A B
x 1 1
y 1 1

instead of
A B
x 5 11
y 8 16

some tips ?

thank you

"Dave Peterson" wrote:

It looks like you could use a pivottable to do this.


--

Dave Peterson