Husker87:
tyr, Link:=True
Worksheets("Sheet1").Range("A1:D10").Copy
Sheets("Sheet2").Range("A1").Activate
ActiveSheet.Paste Link:=True
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Husker87" wrote:
Thanks for the reply. I think that will work. How do I get the macro to run
each time the workbook is saved or can I get the date to be constantly
updated?
"chijanzen" wrote:
Husker87:
try , PasteSpecial method
Worksheets("Sheet1").Range("A1:D10").Copy
Worksheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteValues
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"Husker87" wrote:
I have a macro that copies some data to another worksheet in the workbook.
It copies the data as values only. (Some of the date in the first worksheet
is result of formulas and I just want the data to be copied) Anyway, how can
I run the macro each time the workbook is saved so that the second worksheet
always has update data in it? Any ideas?