Results 1 to 5 of 5

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

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2008
    Location
    England
    Posts
    4

    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
    Last edited by eludlow; 10-06-2009 at 05:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1