Forum Discussion

TMToronto's avatar
TMToronto
Copper Contributor
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

3 Replies

  • TMToronto's avatar
    TMToronto
    Copper Contributor

    Thank you very much - it does exactly what I need it to do.

    I tried to view macros but none showed.

    Would you kindly explain or direct me to resources that will teach me how to accomplish this functionality?

    I will need to apply it in other areas of my document.

    Thank you for your help.

  • TMToronto's avatar
    TMToronto
    Copper Contributor

    Thank you very much for your quick reply and file - it does exactly what I was hoping to accomplish.

    Can you please point me in the direction of resources that explain how you accomplished this functionality?

    I tried to 'view macros' but did not see any.

    I need to understand how to do this so that I can apply it to the rest of the document I plan to create for the team.

    Thank you.

  • NikolinoDE's avatar
    NikolinoDE
    Platinum 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