Google Sheets — How to make interdependent cells from different sheets of one book?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
274 views
Good time of day!
With a similar question on the Toaster already familiar. The days of Google and ignorance of the js did not help to adapt this or other scripts under my conditions.
Script№1(do not read GS'ohms)
Private Sub Worksheet_Change (ByVal Target As Range)
If Not Intersect(Target, Union([A1],[B1])) Is Nothing Then
Application.EnableEvents = False
[B1]= Target
[A1]= Target
Application.EnableEvents= True
End If
End Sub
by | 274 views

1 Answer

0 like 0 dislike
You can write a macro that will fire when you change the values in the cells. Private Sub Worksheet_Change(ByVal Target As Range). Indicate the range in which to track changes and then write the condition whether the cell in the specified range. If it does, drive one to the watches array, remove the second and insert the array data into the same range. Not only cycle, but how long will work. Copy and paste using Range.
PS. Macro to change cell values inserted into the module sheet.
by

Related questions

0 like 0 dislike
5 answers
0 like 0 dislike
2 answers
0 like 0 dislike
6 answers
0 like 0 dislike
1 answer
asked Mar 24, 2019 by opposite
0 like 0 dislike
1 answer
asked Mar 26, 2019 by namespace
110,608 questions
257,187 answers
0 comments
40,253 users