Hamond
12-14-2007, 10:04 AM
Hi,
I know what I need done and how to do it but don't know how to automate hence I thought I'd give this forum a go. I could do it manually but it would take me ages! I'd describe my VBA knowledge as very basic in most areas.
Here's what I'm seeking to do.
I have four sheets in the same workbook:
Source Sheet - consists of 200 columns of data starting column B
Calculation Sheet - consists of some data and calculations
Results sheet - consists of results from the calculations
Results Copy - consists of a copy of the results from the results sheet
What I want to do is take each column of data from the source sheet, put it into column B (B3) of calculation sheet. Then run a macro, this performs calculations on the data in column B and data in other columns of the same sheet that does not change. When the macro is done, (a couple of seconds), it pastes the results in the results sheet (a1), I want to take a copy of these results and paste into a results copy.
I then want to repeat the same steps/cycle for the next variable in the source sheet (column C). But when copying from results sheets to Results Copy sheet, I don't want to paste over the results from the previous variable, so I need to paste the data underneath the previous results, say separating them by one row or something.
Would be greatful for any ideas, recommendations and advice.
Thanks,
Hamond
I know what I need done and how to do it but don't know how to automate hence I thought I'd give this forum a go. I could do it manually but it would take me ages! I'd describe my VBA knowledge as very basic in most areas.
Here's what I'm seeking to do.
I have four sheets in the same workbook:
Source Sheet - consists of 200 columns of data starting column B
Calculation Sheet - consists of some data and calculations
Results sheet - consists of results from the calculations
Results Copy - consists of a copy of the results from the results sheet
What I want to do is take each column of data from the source sheet, put it into column B (B3) of calculation sheet. Then run a macro, this performs calculations on the data in column B and data in other columns of the same sheet that does not change. When the macro is done, (a couple of seconds), it pastes the results in the results sheet (a1), I want to take a copy of these results and paste into a results copy.
I then want to repeat the same steps/cycle for the next variable in the source sheet (column C). But when copying from results sheets to Results Copy sheet, I don't want to paste over the results from the previous variable, so I need to paste the data underneath the previous results, say separating them by one row or something.
Would be greatful for any ideas, recommendations and advice.
Thanks,
Hamond