•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to make 2 different cells act as one.
Our take
Are you looking to make two separate cells behave as one in your spreadsheet? Specifically, you want changes in one cell to reflect in another, even across different sheets and tables. While using a formula like =A1 can update one cell based on another, achieving a two-way link requires a more advanced approach. In this discussion, we’ll explore methods to synchronize values between cells, ensuring that updates in either location are mirrored seamlessly. Let’s dive into the solutions that can empower your data management!
Hello all. I have been trying to figure out how to make two different cells act as one cell. I understand I can make the function =A1 and if I update A1 the cell with the function updates as well, but is there a way to make two different cells such as A1 and C3 act as the same cell? For example, if i update a value in A1 it updates in C3, but if I update C3 it will also update A1? I am specifically using this across two different sheets in the same workbook and two different tables. I appreciate the help and look forward to hear your replies.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#google sheets#financial modeling with spreadsheets#Excel alternatives#cells#A1#C3#update#same cell#workbook#function#sheet#table#different sheets#value#function updates