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

A	B	C	D	E	F	G	H	I	J	K	L
Total	Used	Remain	%Used	%Remain	Total %	Total	Used	Remain	%Used	% Remain	Total %
40	5	6	12	15	72	50	12	14	24	28	48

<tbody>
</tbody>

---

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).