hi all
I need a little help to my vab
i want to add auto copy after every calculation done in my workbook or worksheet to this vba
taking to consideration to add these results to the next empty cell
and the results be paste especial Value
sub copy_method()
Workbooks("New Data.xlsx").Worksheets("Export").Range("A2:D9").Copy _
Workbooks("Reports.xlsm").Worksheets("Data").Range("A2")
end sub
thanks
I need a little help to my vab
i want to add auto copy after every calculation done in my workbook or worksheet to this vba
taking to consideration to add these results to the next empty cell
and the results be paste especial Value
sub copy_method()
Workbooks("New Data.xlsx").Worksheets("Export").Range("A2:D9").Copy _
Workbooks("Reports.xlsm").Worksheets("Data").Range("A2")
end sub
thanks
Last edited: