Remove simple multiplication from formulas in a selection of cells

[shikiori]

I have a sheet with a table of data that is copied and pasted as a Link, so each cell in the copied table contains a formula of the format =G41 (column / row obviously changes from cell to cell across the table referring to the source from which it was copied).

I have a series of 10 buttons with this macro modified and assigned to them, to allow the user to select cells and add a multiplier of 1 to 10 to the formulas in the selected cells. For example, user selects a bunch of cells and chooses to multiply them by 7 using the corresponding button. In the case of my example cell above, the formula is modified to be =G41*7.

Is there a macro that can be created to remove the multiplication from selected cells, where the multiplication may be the same or different (from 1 to 10) across the selection?

For example, user selects three cells that have had multiplication added to their formula, let's say =G41*7, =B32*7, and =C99*2 and presses this 'remove' macro and reverts the three cells to have formulas revert to =G41, =B32, and =C99. Something that removes all the characters to the right of the * (which I understanding in theory can be done) and then the * itself as well perhaps?

Complete Excel Luddite here, so I appreciate any help! TIA

 

[Herakles]

I have a sheet with a table of data that is copied and pasted as a Link, so each cell in the copied table contains a formula of the format =G41 (column / row obviously changes from cell to cell across the table referring to the source from which it was copied).

I have a series of 10 buttons with this macro modified and assigned to them, to allow the user to select cells and add a multiplier of 1 to 10 to the formulas in the selected cells. For example, user selects a bunch of cells and chooses to multiply them by 7 using the corresponding button. In the case of my example cell above, the formula is modified to be =G41*7.

Is there a macro that can be created to remove the multiplication from selected cells, where the multiplication may be the same or different (from 1 to 10) across the selection?

For example, user selects three cells that have had multiplication added to their formula, let's say =G41*7, =B32*7, and =C99*2 and presses this 'remove' macro and reverts the three cells to have formulas revert to =G41, =B32, and =C99. Something that removes all the characters to the right of the * (which I understanding in theory can be done) and then the * itself as well perhaps?

Complete Excel Luddite here, so I appreciate any help! TIA

Put the multiplication factor, the 7, into another cell, and refer to that cell in the formula. Change it to 1 when you want to remove the multiplication.