EXCEL how to realize the two data in a cell is consistent, namely if I modify any one cell data

My table data is A4=A2 * A3 A4=A7, A8 my request, whatever I lose such as A4, A7, A8 the three cell data will be synchronized to three cells and A2, A3, as shown in figure , the corresponding lines of each column to be like this! Details you can send me E-mail thank you! 1397101413 @qq.com

CodePudding user response:

oneself sit sofa

CodePudding user response:

Why not, find another cell, such as A1, the three original needs to be synchronized to=A1, when wanting to change only change A1,

CodePudding user response:

I've tried this, do you want to take a look at the inside of the form of A4=A2 * A3 A4=A7=A8

CodePudding user response:

Table data is A4=A2 * A3 A4=A7: A8 my request, whatever I lose such as A4, A7, A8 data synchronization to the three cell,,,
-- - your problem is not clear, the first A4=A2, A3, A4 then how can you manually input anymore?
A4=A7, A8 is write wrong? Is A4=A7=A8? Filled out A7=$A $4 A8=$A $4

CodePudding user response:

The language is not good, didn't understand

CodePudding user response:

Private Sub Worksheet_Change (ByVal Target As Range) tried not
Relationship is written in the program, a related automatic change
Don't forget to disable before the event, after recovery, otherwise the infinite loop