Home |
Search |
Today's Posts |
#1
|
|||
|
|||
data entry from two cells across worksheets
I'm wanting to have cells take the value of the last one updated across
worksheets. I've found the code that accomplishs this within one worksheet, but not across two. Could anyone make ammendments to the following code for me? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Range("A1").Value = Range("A2").Value ElseIf Target.Address = "$A$1" Then Range("A2").Value = Range("A1").Value End If End Sub Thanks greatly Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |