[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
<tbody>
</tbody>
Table 2 - I only need to copy and paste value from column A and G and other values to remain same... thoughts?
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?