Need a Macro to swap Data with a click of a Button

Sample Data.xlsm

(Sample Data Attached, Student names have been changed to X for data protection)

Hi all, I work in a school and have created this spread sheet for grade analysis.

I am after (what seems to me a complex VBA) macro that will change a certain Criteria in the cells of the table. I would like the macro to pick out all of *3 grades and change them to the corresponding *1 Grade. Here is a table of what I need converting.
A*3 To A1
A3 To B1
B3 To C1
C3 To D1
D3 To E1
E3 To F1
F3 To G1

Then... If a grade is changed the number to the right of the changed grade needs to change by subtracting 2 from it.
The table has a range of Data but it is only the data ending in 3 that needs to be converted with their numbers, the rest can stay the same.
There is 3 Red columns in the table, these are targets and need to stay fixed (so the macro doesn't apply to these columns).

Then along the top I need two buttons - "X2 Secure" which will activate the macro and "X3 Secure" which will reset the Macro. the button needs to stay Highlighted so we know which one is selected.
FYI-The grade data gets updated after every Data capture and I use this spread sheet for all year groups (multiple versions) So maybe this work book needs to be a template for me to drop the data in??

It would be amazing if this is possible.

Thanks

I think (if I understand correctly) you are over complicating your requirements.

use the developer tab to draw two buttons at the top of your sheet.

1) Record a macro 'ChangeUp' select the ranges required (without the fixed columns) using (selection + add selection) then Click 'Find/Select, 'Replace. 'Find A3 'Replace with A1 ' Replace All, 'OK. Do this for b,c,d,e,f. Stop the Macro. Right click 'Button 1 and assign the 'ChangeUP macro.

2) Record a Macro 'ChangeDown select the same ranges and use find and replace but in the reverse order then assign button 2 to this macro.

A quick tester below

Sample Data.xlsm