| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
| Referencing sheet1 from sheet2 | Excel Worksheet Functions | |||
| go to sheet1 to sheet2 | Excel Programming | |||
![pano[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
