Forum Discussion

TMToronto's avatar
TMToronto
Occasional Reader
Sep 24, 2025

Have multiple CONVERT cells update when any one cell's value is changed

I want to create an excel document that helps my team set correct parameters (Max feed rate, acceleration, etc...) for various CNC machine controllers that use different units of measurement.

I know the formulas, and understand how CONVERT works, and can set it up so that, for example ## "/min in one cell converts to ##mm/s in another.

What I would like to do is have this work so that when any of the cell values are changed all the rest of the related cells update accordingly based on the conversion applied to their cell.

For example, depending on the machine and controller, I can have axis accelerations presented in four different units:

mm/s^2          mm/min^2       in/s^2          in/min^2

 

I would like to be able to have all four of the above cells be populated with the correct acceleration value, and when any one of the four is updated the remaining three cells are all automatically updated to reflect this change.

My initial research shows I will likely need to use Macros/VBA, but I have yet to come across an example use case similar to mine.

I would appreciate knowing if this can be done, if I am on the right track with using macros, and any suggestions as to how it can be accomplished. If I can get it to work for the above example I feel I can take that experience and apply it to the other parameters.

Thank you,

Tom

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    If I understand correctly, the inserted file should work as you wish 🙂

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

Resources