•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
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]
Want to read more?
Check out the full article on the original site
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