+ Reply to Thread
Results 1 to 3 of 3

Copy column B. C. D etc. below the data/text in column A

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    New York, New york
    MS-Off Ver
    Excel 2007
    Posts
    1

    Copy column B. C. D etc. below the data/text in column A

    Hello! I looked through old forum posts and used this macro but it's not capturing all the data. I have a data set of 1144 values (88 columns and 13 rows) but when I run the macro it's only capturing 1057 rows of data. Any idea what's breaking?

    I want to Cut column B and Paste underneath column A, then cut column C and paste underneath column A etc etc until the data runs out. I may have more values than 1144 in the future.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 03-25-2024 at 02:03 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Copy column B. C. D etc. below the data/text in column A

    Please use code tags round VBA code. I've added it this time.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,215

    Re: Copy column B. C. D etc. below the data/text in column A

    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. [SOLVED] VB Code to find certain text in column and copy digit part in diff column
    By rmomin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2021, 07:12 AM
  2. [SOLVED] Macro to Copy and Paste Specific Text in Column A on the last line with Text in Column B?
    By D2S in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2017, 04:08 PM
  3. Copy data from sheet1 column with dynamic date, and copy data to second sheet column
    By Renaliiii in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2016, 04:44 PM
  4. [SOLVED] Copy column B. C. D etc. below the data/text in column A
    By s.farrelly in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-07-2014, 10:59 AM
  5. Replies: 1
    Last Post: 12-10-2013, 05:23 PM
  6. [SOLVED] copy selected data into column A cells if column B contains text
    By El Conquistador in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2013, 02:51 PM
  7. Copy data from column K to column B if Column C and column I match
    By goog2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2013, 12:19 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