+ Reply to Thread
Results 1 to 5 of 5

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

  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.

  2. #2
    Forum Contributor
    Join Date
    03-25-2008
    MS-Off Ver
    Excel, Outlook, Word 2007/2003
    Posts
    245

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

    Please Login or Register  to view this content.
    Charlize

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

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

    If I've understood, perhaps:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    03-25-2008
    MS-Off Ver
    Excel, Outlook, Word 2007/2003
    Posts
    245

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

    Starting from the previous coding but added the saving routine.
    Please Login or Register  to view this content.
    Charlize
    Last edited by Charlize; 10-06-2009 at 08:56 AM.

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

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

    Many thanks all - a bit of all of the above code, plus a bit of reading up on VBA, and I've got it working.

    Ed

+ Reply to Thread

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