Forum Discussion
Solved
copy data to different worksheet
HansVogelaar Sir I have a two different excel file 1.copy.xls(Running in compatibility mode) 2.paste.xlsm in copy.xls sheet2 having "if" formula in D2. When condition match in D2 get "Y...
Right-click the sheet tab of Sheet1.
Select 'View Code' from the context menu.
Copy the following code into the worksheet module:
Private Sub Worksheet_Calculate() Static OldVal As Variant If Range("C3").Value <> OldVal Then ThisWorkbook.Save OldVal = Range("C3").Value End If End Sub
sir,
it is changing with reference from Realtime data
please find attached .I have changes little
It's dinner time where I live. I'll look at it later.
- ohh! sorry ..Please take ur time.
- I Think due to earlier version of excel (Running compatibility mode) data is not getting transfer to other sorksheet.
It was happening during direct cell reference(="cell no" ) also to other worksheet not working