+ Reply to Thread
Results 1 to 2 of 2

VBA to compile non-blank cells from several columns in one single column

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Taguig City, Philippines
    MS-Off Ver
    MS 2013
    Posts
    1

    VBA to compile non-blank cells from several columns in one single column

    Hi,

    I am fairly new to VBA and survived until today by just copying and pasting codes from the internet. However, I can not seem to find an answer to what I need to do now as I think that it is too simple. Here it is: I have columns that include 15-digit alphanumeric characters (IDs) that differ as to how many rows. All I want to do is to copy the non blank cells in each column and paste them to a new sheet and in just a single column. So if there are 8 rows in Sheet 1, column A, 15 rows in column B and 6 rows in column C that are not blank, I need Sheet 2, Column A to list 29 IDs.

    Also, I am just planning to formulate in Sheet 3 that in every 60 IDs in Sheet 2, Column A, a cell would concatenate the 60 IDs in a single cell and separate them by a comma. I know that this might be easy to do in VBA as well so if you may kindly assist when you're feeling a little generous. It's that season anyways.

    Thanks a lot in advance!

    Marc

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: VBA to compile non-blank cells from several columns in one single column

    Try:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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. Replies: 11
    Last Post: 02-28-2014, 02:40 PM
  2. Replies: 6
    Last Post: 11-29-2013, 10:52 PM
  3. [SOLVED] Removing blank cells from a dependent drop list in a single column
    By Dbeethekidd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2013, 04:15 AM
  4. Compile multiple columns in one column - error?
    By dim06 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-09-2011, 11:23 AM
  5. Replies: 3
    Last Post: 01-07-2010, 02:30 PM

Tags for this Thread

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