I have two worksheets in a workbook, one called Calculations and one called Results. Calculations has a bunch of equations for running some data analysis that iterates through data sets using VBA code and results from each iteration are always output in cells A1:Z1. Results from each iteration need to be stored in the worksheet called Results.
Basically I need some way of copying cells A1:Z1 from Calculations worksheet to Results but each paste operation has to be below the last, e.g.
iteration 1: copy/pastespecial values only A1:Z1 from Calculations to A1:Z1 in Results
iteration 2: copy/pastespecial values only A1:Z1 from Calculations to A2:Z2 in Results
iteration 2: copy/pastespecial values only A1:Z1 from Calculations to A3:Z3 in Results
Etc etc. This process continues for some amount of iterations that is user-defined (I have this bit sorted using a variable).
I imagine there's some combination of pastespecial and xlup commands that can do this but I've tried to write the code without success. Can anyone offer any help?
Thanks in advance.