Tying two cells together so they are MUTUALLY dependent

Hi,

Does anyone know if one could equate two cells in Excel, say A1 and C1, such that if I change A1, then C1 will change to reflect the data of A1, and if I change C1, A1 will reflect the data of C1? I don't believe formulas will permit this since when you enter data into a cell, it removes the formula. But perhaps Excel has another tool for this? I would like to ideally avoid macros because this file would go to a larger audience and so any security concerns would be an inconvenience.

Thank you!

what about establishing two cells as data entry Cells - and two Cells as reults
If you change data in A1 - then B2 would change, change data in B1 then A2 would change?

It would help to have more info.

Originally Posted by CRIMEDOG

what about establishing two cells as data entry Cells - and two Cells as reults
If you change data in A1 - then B2 would change, change data in B1 then A2 would change?

It would help to have more info.

Crimedog, I have about 10 tabs in a workbook that all have a cell in say A1 that should be the same value, as the rest of the formulas depend on what is in A1. If I change A1 to say apple, sheet 1 will show the data of apples in say CA, and sheet 2 the data of apples in say FL. If I change A1 to say bananas, the data will update again. The goal here however is so that users can change this A1 on every sheet, and only do it one time so all other sheets update accordingly. I know this can probably be done quite easily with vba, but would like to avoid it if possible.

Does this additional detail help? Would the consensus still be it's not possible?

how many catagories are there?

Got it.
Isert a form control Combo Box on each sheet using a category list on the first sheet.
See attached.

Originally Posted by CRIMEDOG

Got it.
Isert a form control Combo Box on each sheet using a category list on the first sheet.
See attached.

crimedog, that's actually what I'm thinking that I'd do if the mutually linking cells doesn't work out. The reason I'd prefer to not use form control is that there are actually 200 "fruit types" in my data (sounds like you guessed this when you asked about the number of categories!), and so it's easier for the user to enter it as opposed to scrolling through the list. It doesn't look like the newer Excels support a form control that permits manual entering (I believe I read about how this older MS Excel 5.0 Dialog permitted it, but the older version would not work with my other data manipulations).

that is the best without macros (I think)
I would probably create a little User Form with a text box.
The thing about typing instead of picking from a dropdown: the accuracy is not as good (typos etc...)
Are your "fruit" grouped in categories? (like manufacturers) that would limit the lists?
So- pick manufactuer 1 and then choose from 10 - etc...

Originally Posted by CRIMEDOG

that is the best without macros (I think)
I would probably create a little User Form with a text box.
The thing about typing instead of picking from a dropdown: the accuracy is not as good (typos etc...)
Are your "fruit" grouped in categories? (like manufacturers) that would limit the lists?
So- pick manufactuer 1 and then choose from 10 - etc...

I've been resolving the accuracy concern you listed with data validation, which seems to work well.

The "fruits" are not further groupable in subcategories.

Sounds like my best bet is go with combo box as you listed earlier.

Thank you, everyone!