Hi
I have an excel sheet that performs calculations then i use a macro to copy and paste the results into another sheet. The macro then continues to call in new data from a source and the sheet re-calculates and copy and paste again. The sheet is around 10mb in size.
I have 2 issues. Firstly...