•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Input in one cell to output to another cell and vise versa
Our take
If you're looking to create a dynamic data exchange between two sheets, where input on either sheet reflects on a third, you're not alone. Many users find themselves wishing for seamless synchronization without encountering circular reference errors. While directly linking cells like `=sheet2!A1` in sheet1 and `=sheet1!A1` in sheet2 creates a loop, there are innovative methods to achieve your goal.
I got this error above trying to do the following:
Is there a way to have two sheets output information back and forth depending on which sheet you put information on?
sheet1 '=sheet2!A1' in A1 cell
sheet2 '=sheet1!A1' in A1 cell
I basically I want two input sheets carry over information to a 3rd sheet but the user can pick sheet1 or sheet2 but all info would carry over in order for the reviewer to also pick which sheet to review. Hopefully that makes sense.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#google sheets#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#sheets#output#information#input#error#excel#cell#carry over#formula#reference#third sheet#user#review