Consulting

Results 1 to 4 of 4

Thread: Solved: Help - A question from Ella.

  1. #1
    Knowledge Base Approver VBAX Expert brettdj's Avatar
    Joined
    May 2004
    Location
    Melbourne
    Posts
    649
    Location

    Solved: Help - A question from Ella.

    Help
    I am new to excel macro but I would like to have some codes that will automaticaly select a series of columns from one workbook to another and save it.
    the initial columns are: A, B,C, D, E, G, H, I, J, K, L, M, N, O,P and so on. I would like to be able to copy for instance B, D,G, I, K, M, P and so on --to another workbook.

    I will really appreciate your help

    Thanks

    Ella

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,710
    Location
    Try something like:
    [vba]
    Workbooks("Workbook With Data Name").Sheets("Sheet1").Range("B:B").Copy _
    Destination:=Workbooks("New Workbook Name").Sheets("Sheet1").Range("B:B")[/vba]

  3. #3
    VBAX Newbie
    Joined
    Apr 2005
    Posts
    1
    Location
    I tried and it is working.
    Thanks so much

    Ella

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,710
    Location
    You're Welcome

    Take Care

Posting Permissions

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