|
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
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 |
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
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 |
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
|
| All times are GMT +1. The time now is 01:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com