More specified repost on macros buttons
I have never used macros in Excel, only formulas, but if someone who knows about macros could help that would be great. I’m trying to use the “record” action, but don’t know exactly how to do that. I want a button to perform the following functions: test the positive and negative numbers in a set of cells (I2:K8) by inserting each one into cell A1 until cell G3 equals 0, then list the number in A1 that results in 0 in cell B6 as “(x-number)” Then the numbers in cells B3:G3 to be put into corresponding cells B1:G1, NOT counting the repeating zeros at the end, but DO count zeros in between numbers (eg, count the 0 in 12034, but not in 12340)
Then all the above needs to be repeated until there are no more numbers, and after each round the resulting “(x-number)” needs to be moved a cell over (eg, the first round results in (x-number) in cell B6, the second round results in (x-number) in cell B7, and so on), until no more numbers remain in cells C1:G1.
ALSO… if none of the numbers in cells I2:K8 result in 0, the process above needs to stop, and say something like (unreal number) in the cell after the last (x-number) in row 6, and leave the remaining numbers alone.
If you know anything about the synthetic division of polynomials it might help, as that’s what I’m trying to accomplish. If you have any questions or if I didn’t explain something well enough please let me know.
I have never used macros in Excel, only formulas, but if someone who knows about macros could help that would be great. I’m trying to use the “record” action, but don’t know exactly how to do that. I want a button to perform the following functions: test the positive and negative numbers in a set of cells (I2:K8) by inserting each one into cell A1 until cell G3 equals 0, then list the number in A1 that results in 0 in cell B6 as “(x-number)” Then the numbers in cells B3:G3 to be put into corresponding cells B1:G1, NOT counting the repeating zeros at the end, but DO count zeros in between numbers (eg, count the 0 in 12034, but not in 12340) Then all the above needs to be repeated until there are no more numbers, and after each round the resulting “(x-number)” needs to be moved a cell over (eg, the first round results in (x-number) in cell B6, the second round results in (x-number) in cell B7, and so on), until no more numbers remain in cells C1:G1.ALSO… if none of the numbers in cells I2:K8 result in 0, the process above needs to stop, and say something like (unreal number) in the cell after the last (x-number) in row 6, and leave the remaining numbers alone. If you know anything about the synthetic division of polynomials it might help, as that’s what I’m trying to accomplish. If you have any questions or if I didn’t explain something well enough please let me know. Read More