COPY and Paste selected cells (2nd)

[trimiii]

[h=2]Fellas,[/h]

I have 365 daily reports that I have to go thru and change Total on every report and it will be time consuming which I need help please.

My report is as follows:

Column A:BC (55 lines) and I need to change only the flowing:
I only need assistance able to copy and paste the values only for selected columns (example column A and G) and paste to the next row

Questions: how do I copy and paste value only for the above columns in to new format?

This is my table 1
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[/TR]
[TR]
[TD="align: center"]Total[/TD]
[TD="align: center"]Used[/TD]
[TD="align: center"]Remain[/TD]
[TD="align: center"]%Used[/TD]
[TD="align: center"]%Remain[/TD]
[TD="align: center"]Total %[/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"]Used[/TD]
[TD="align: center"]Remain[/TD]
[TD="align: center"]%Used[/TD]
[TD="align: center"]% Remain[/TD]
[TD="align: center"]Total %[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]48[/TD]
[/TR]
</tbody>[/TABLE]

---

Table 2 - I only need to copy and paste value from column A and G and other values to remain same... thoughts?​

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1108660-copy-paste-post5335493.html#post5335493

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).