Looping through columns to copy output into other sheet, and saving output

Hi all.

I'm pretty much a noobie to VBA coding, despite being fairly experienced in other (mainly web..) programming languages.

I have a scenario that I think can be overcome pretty easily with some VBA, but I'm not sure...if I explain, hopefully some of you will be able to help with some pointers etc.

I have a worksheet (let's say WorkSheet1), which if you like is my "output" template: in one column I enter a load of variable data, which is then manipulated later in the sheet to perform some data analysis.

I need to perform this analysis on about 100 sets of data, which all sit in another worksheet (WorkSheet2...), a column per set of data.

How easy is it to:
- copy column A from WorkSheet2 into column A of WorkSheet1, and then save that sheet as let's saying the value of A1
- then repeat that for WorkSheet2, columns B, C, D etc etc...

Many thanks,
Ed

If I've understood, perhaps:

Please Login or Register  to view this content.

Starting from the previous coding but added the saving routine.

Please Login or Register  to view this content.

Charlize