+ Reply to Thread
Results 1 to 5 of 5

VBA Copy Paste data from every second column

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    48

    VBA Copy Paste data from every second column

    Evening folks, hope you can help

    I was looking for a piece of code to allow the following:

    I need to copy the data from K6:K24, and every second column from there up to ZY6:ZY24. The sheet name is DailyUpdate.

    I then need to paste the data into another sheet called DailyUpdateFinal in the same positions

    thanks

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: VBA Copy Paste data from every second column

    Try on a copy of your data...

    Please Login or Register  to view this content.
    Double check colored line to see if that is the ending column you seek.
    Last edited by jeffreybrown; 10-03-2018 at 07:05 PM.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    10-09-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2016
    Posts
    48

    Re: VBA Copy Paste data from every second column

    Almost right

    As you said, the end column was off, but changed to 699 and it works perfect.

    Brilliant thanks.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: VBA Copy Paste data from every second column

    Isn't Column ZY Column 701?

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: VBA Copy Paste data from every second column

    You are very welcome and thanks for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy data and paste to another column incrementing that column to next empty cell
    By edens2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2015, 11:43 AM
  2. [SOLVED] Copy all cells in column that contain data & paste to first empty row of another column.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2014, 08:45 AM
  3. Copy and Paste data in column A number of times displayed in column B
    By anthony232 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2013, 05:13 PM
  4. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  5. Replies: 3
    Last Post: 08-28-2012, 10:09 AM
  6. VBA Code to copy data from last filled column and paste to the next available column.
    By Pavman2473 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2012, 09:07 PM
  7. Macro to copy and paste special values for column data and filter column data
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2012, 02:15 PM

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