EXCEL SHEET FORMULA
Closed
roula
-
Oct 22, 2009 at 08:55 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 22, 2009 at 10:38 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 22, 2009 at 10:38 PM
Related:
- EXCEL SHEET FORMULA
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- How to screenshot excel sheet - Guide
- How to transfer data from one sheet to another in excel using formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 22, 2009 at 10:38 PM
Oct 22, 2009 at 10:38 PM
you mean whatever you have entered in A1 whne R1 is entered that value will be entered in A1 also
right click the sheet tab click viewcode and copy this event code
if this is confirm
right click the sheet tab click viewcode and copy this event code
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$R$1" Then Exit Sub
Range("A1") = Target
End Sub
if this is confirm
