Combine values and SUM duplications - help needed as my way is veeeeerrrrryy slow :(

[LORDMARKS]

Hi all

I have a large data table in varying size 300 - 6000 rows, 20 columns.

I am trying to sort the data for display purposes, mainly graphs, so I am using..

Sheets("Data Display").Range("B33:B6033").SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets("Calc").Range("A10000")

and

Sheets("Calc").Range("O116:O6116").Value = Sheets("Calc").Range("I10000:I16000").Value

(this is just a sample of the lines) to bring the data in and convert to values, but what I need to do is combine two columns and plot againts the third, but at the same time add together any duplicates.

So to explain better... Column A (name) Column B (ref#) Column C (value)

result...Column A (name&ref#) Column C (value)
check...Column A for repeats and total values



I was trying a combination of unique INDEX and SUMIF as a fixed calculation along side the data, but as this appears to be VOLITILE the calculation time is massive!

If anyone has a better suggesetion, please let me know. or if I can do this as part of the code on import?


Thanks As Always.