Thread
:
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
View Single Post
#
3
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
Not sure what you solution has to do with the original question? Is the
question correct?
--
Regards,
Nigel
"pano" wrote in message
oups.com...
On Oct 28, 1:15 pm, pano wrote:
Hello,
A1 Sheet2 is linked to A1 sheet1 so that user types in (abc123) a1
sheet1 and A1 sheet2 is updated, what I would like to know can I also
somehow enter BBB 444 on sheet3 A1 and have it replace ABC123 on
sheet1 A1 and have it update A1 sheet2 with BBB 444.
Hope that is explained well enough
thanks
I have'nt been waiting for an answer best I could come up with is the
following
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address < "$H$19" Then Exit Sub
'Code to run because H19 car rego changed .
Application.ScreenUpdating = False
Worksheets("Back1").Range("H5:H40").ClearContents
Worksheets("Back1a").Range("H5:H40").ClearContents
Worksheets("Back2").Range("H5:H40").ClearContents
Worksheets("Back2a").Range("H5:H40").ClearContents
Worksheets("Back3").Range("H5:H40").ClearContents
Worksheets("Back3a").Range("H5:H40").ClearContents
Worksheets("Back4").Range("H5:H40").ClearContents
Worksheets("Back4a").Range("H5:H40").ClearContents
Worksheets("Back5").Range("H5:H40").ClearContents
Worksheets("Back5a").Range("H5:H40").ClearContents
Worksheets("Back6").Range("H5:H40").ClearContents
Worksheets("Back6a").Range("H5:H40").ClearContents
Worksheets("Back7").Range("H5:H40").ClearContents
Worksheets("Back7a").Range("H5:H40").ClearContents
Worksheets("Back8").Range("H5:H40").ClearContents
Worksheets("Back8a").Range("H5:H40").ClearContents
Worksheets("Back9").Range("H5:H40").ClearContents
Worksheets("Back9a").Range("H5:H40").ClearContents
Worksheets("Back10").Range("H5:H40").ClearContents
Worksheets("Back10a").Range("H5:H40").ClearContent s
Worksheets("Back11").Range("H5:H40").ClearContents
Worksheets("Back11a").Range("H5:H40").ClearContent s
Worksheets("Back12").Range("H5:H40").ClearContents
Worksheets("Back12a").Range("H5:H40").ClearContent s
Worksheets("Back13").Range("H5:H40").ClearContents
Worksheets("Back13a").Range("H5:H40").ClearContent s
Worksheets("Back14").Range("H5:H40").ClearContents
Worksheets("Back14a").Range("H5:H40").ClearContent s
Worksheets("Back15").Range("H5:H40").ClearContents
Worksheets("Back15a").Range("H5:H40").ClearContent s
Worksheets("Back16").Range("H5:H40").ClearContents
Worksheets("Back16a").Range("H5:H40").ClearContent s
Worksheets("Back17").Range("H5:H40").ClearContents
Worksheets("Back17a").Range("H5:H40").ClearContent s
Worksheets("Back18").Range("H5:H40").ClearContents
Worksheets("Back18a").Range("H5:H40").ClearContent s
Worksheets("Back19").Range("H5:H40").ClearContents
Worksheets("Back19a").Range("H5:H40").ClearContent s
Worksheets("Back20").Range("H5:H40").ClearContents
Worksheets("Back20a").Range("H5:H40").ClearContent s
Worksheets("Back21").Range("H5:H40").ClearContents
Worksheets("Back21a").Range("H5:H40").ClearContent s
Worksheets("Back22").Range("H5:H40").ClearContents
Worksheets("Back22a").Range("H5:H40").ClearContent s
Worksheets("Back23").Range("H5:H40").ClearContents
Worksheets("Back23a").Range("H5:H40").ClearContent s
Worksheets("Back24").Range("H5:H40").ClearContents
Worksheets("Back24a").Range("H5:H40").ClearContent s
Worksheets("Back25").Range("H5:H40").ClearContents
Worksheets("Back25a").Range("H5:H40").ClearContent s
Worksheets("Back26").Range("H5:H40").ClearContents
Worksheets("Back26a").Range("H5:H40").ClearContent s
Worksheets("Back27").Range("H5:H40").ClearContents
Worksheets("Back27a").Range("H5:H40").ClearContent s
Worksheets("Back28").Range("H5:H40").ClearContents
Worksheets("Back28a").Range("H5:H40").ClearContent s
Worksheets("Back29").Range("H5:H40").ClearContents
Worksheets("Back29a").Range("H5:H40").ClearContent s
Worksheets("Back30").Range("H5:H40").ClearContents
Worksheets("Back30a").Range("H5:H40").ClearContent s
Worksheets("Back31").Range("H5:H40").ClearContents
Worksheets("Back31a").Range("H5:H40").ClearContent s
Worksheets("Back32").Range("H5:H40").ClearContents
Worksheets("Back32a").Range("H5:H40").ClearContent s
Worksheets("Back33").Range("H5:H40").ClearContents
Worksheets("Back33a").Range("H5:H40").ClearContent s
Worksheets("Back34").Range("H5:H40").ClearContents
Worksheets("Back34a").Range("H5:H40").ClearContent s
Worksheets("Back35").Range("H5:H40").ClearContents
Worksheets("Back35a").Range("H5:H40").ClearContent s
Application.ScreenUpdating = True
End Sub
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]