26th January 2011, 04:28 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
|
|
Ok fixed that issue, it was not clearing old data should be ok now.
The formula problem is more difficult because it only copies values and to copy formula you have the issue of the name ranges and formula references.
unless you need to update the sheet putting the formulas you need on the main sheet to do all your calcs is the best option then the final result will be copied to a separate sheet.
|