Consolidate of data

[klb546]

Hi there ,
Is there a method(VBA or formula) to to consolidate the data in COLUMN A and sum values of COLUMN C and append COLUMN D to to another new column F, G, H, I per attached file using excel 2010
Thanks
klb546s

 

[vletm]

Yes.
And after You have uploaded a sample file You would get a quicker response
or
do You need also PDF?

 

[klb546]

Hi,
since I am not very good at producing vba macros , will appreciate very much if can help me on how to write a macro for this. I do not need the pdf file. I think i upload the wrong file. Anyway here is the attached excel file. Sorry for any confusion caused.
Thanks
Regards
klb546

 

[vletm]

Something like this
press [do it] ?

 

[klb546]

Something like this
press [do it] ?

Yes,
its something like that , thanks that is what i needed, what if i want the consolidated data to be transfer to another sheet say the name is 'Sorted' how do I do it?
Thank You very much.
Regards
klb546

 

[bosco_yip]

Consolidated data transfer to another 'Sheet Sorted',

Try this formula way with helper as attached file.

Regards

 

[vletm]

@klb546 - Okay ...
I added that feature too.
You have to give the name of result sheet and left top corner's position.
Note: all old data will cleared after [do it] press from the result sheet.

 

[klb546]

Consolidated data transfer to another 'Sheet Sorted',

Try this formula way with helper as attached file.

Regards

Hi bosco,
Thanks very much for the formula way.
Regards
klb546

 

[klb546]

@klb546 - Okay ...
I added that feature too.
You have to give the name of result sheet and left top corner's position.
Note: all old data will cleared after [do it] press from the result sheet.

Hi Vletm,
thank you very much. This should do it.
Regards
klb546