I'm trying to edit cells between sheets. Let's say for instance D5 on Sheet 2, and F5 In Sheet 4. Both of these cells are the same value, and I'd like to be able to update the cells in either sheet, depending on where I am in my workbook at the time.
I tried to link them, but excel gave me a warning about it? My attempt was clicking on D5 in Sheet 2, and typing =F5 in sheet 4. But this only allows a one way link so to speak. I'd like it to go both ways, but unfortunately I don't know enough about excel to figure it out. Google results in really the only method I figured out so far.
I'd really appreciate some help with this!
I tried to link them, but excel gave me a warning about it? My attempt was clicking on D5 in Sheet 2, and typing =F5 in sheet 4. But this only allows a one way link so to speak. I'd like it to go both ways, but unfortunately I don't know enough about excel to figure it out. Google results in really the only method I figured out so far.
I'd really appreciate some help with this!
