<div>
Thank you Rob.<br />
<br />
i need to do this everyday for a new set of data and pivot table can take alot of time. &nbsp;would this be possible to be done programmatically using VBA?<br />
<br />
thanks again
</div>


Thank you Rob.

i need to do this everyday for a new set of data and pivot table can take alot of time.  would this be possible to be done programmatically using VBA?

thanks again

<div>
Dear Rob, <br />
<br />
I think i am going to accept and use the solution you have provided.<br />
<br />
i think this is the best way to do this. <br />
<br />
thank you very much for your help.
</div>


Dear Rob,

I think i am going to accept and use the solution you have provided.

i think this is the best way to do this.

thank you very much for your help.

<div>
If you leave the pivot with links to the source data and copy/paste elsewhere each time, you can then just update source with new data, refresh pivot, copy elsewhere again.<br />
<br />
The pivot data range can be dynamic for when the size of the data changes.<br />
<br />
Thanks<br />
Rob
</div>


If you leave the pivot with links to the source data and copy/paste elsewhere each time, you can then just update source with new data, refresh pivot, copy elsewhere again.

The pivot data range can be dynamic for when the size of the data changes.

Thanks
Rob

<div>
Thank you Rob.<br />
<br />
this is very helpful
</div>


<div>
<div class="content wysiwyg-content">
please see attached File. <br />
<br />
I have two tables, &nbsp;the current one and the result needed.<br />
<br />
i need to VBA that when i run in on current it make it like the &quot;result needed&quot;<br />
<br />
basically, i have a huge data that i want to get rid of the identical rows by summing thier Order total and then deleting them. <br />
<br />
thank you.<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/11_w45/881557/EE.xlsx" target="_blank" class="file-inline" title="EE.xlsx (16 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>EE.xlsx</a>
</div>
</div>


EE.xlsx

please see attached File. 

I have two tables,  the current one and the result needed.

i need to VBA that when i run in on current it make it like the "result needed"

basically, i have a huge data that i want to get rid of the identical rows by summing thier Order total and then deleting them. 

thank you.

Excel VBA Sum amount of identical rows and delete duplicate

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.