Same info and calculations

Occasional Visitor
Can I calculate something in one excel work book and it automatically change to same in another workbook?
1 Reply


Yes, it is possible under certain conditions, e.g. with VBA. But this requires knowledge of VBA.


With your permission, I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.


In this link you will find some more information about it:

Welcome to your Excel discussion space!


Thank you for your understanding and patience



I know I don't know anything (Socrates)