+ Reply to Thread
Results 1 to 2 of 2

List & replicate cells A1,B1,C1 based on non blank cells D1:BK1, same thing down to row20

  1. #1
    Registered User
    Join Date
    12-05-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    1

    Question List & replicate cells A1,B1,C1 based on non blank cells D1:BK1, same thing down to row20

    HI,

    I'm not really sure how to describe this problem, it's a simple concept I think but my excel/vba knowledge is limited and im struggling to find a solutions.
    So the data i have looks like this, where the first three columns A,B,C are simply dates going down to lets say row 20, Columns D:BK are similar to what is below (mixture of letters/numbers) and I want to perform some function or macro that takes me from Figure 1, to Figure 2.

    Figure1:

    1/2/2015 1/3/2015 1/5/2015
    1/15/2015 1/16/2015 1/5/2015 abc123 abc345
    1/22/2015 1/23/2015 1/20/2015 aab123
    1/29/2015 1/30/2015 1/13/2015 cba123 cbb123 cbc432
    1/22/2015 1/23/2015 1/20/2015

    Figure2:

    1/2/2015 1/3/2015 1/5/2015
    1/15/2015 1/16/2015 1/5/2015 abc123
    1/15/2015 1/16/2015 1/5/2015 abc345
    1/22/2015 1/23/2015 1/20/2015 aab123
    1/29/2015 1/30/2015 1/13/2015 cba123
    1/29/2015 1/30/2015 1/13/2015 cbb123
    1/29/2015 1/30/2015 1/13/2015 cbc432
    1/22/2015 1/23/2015 1/20/2015

    I appreciate any help, input, suggestion or anything, I'm either overlooking something simple or I don't know it all together but there must be a standard solutions for this.

    Thank you!

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: List & replicate cells A1,B1,C1 based on non blank cells D1:BK1, same thing down to ro

    Welcome to the board! My brain is sluggish this morning, so I bailed on trying to do this with formulas, but the following procedure should work:

    Please Login or Register  to view this content.
    See the attached for added clarity
    Attached Files Attached Files

+ 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: 3
    Last Post: 11-16-2016, 04:04 PM
  2. [SOLVED] Ignore Blank Cells for Criteria based Combobox list
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2016, 09:51 AM
  3. Count blank cells in a range and contiguous blank cells also as single cells! Tricky One!
    By SebastianColombia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2015, 02:32 PM
  4. Can't replicate code in multiple cells? List selection -> attach document
    By VeryButtery in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2015, 05:37 AM
  5. VBA: Copy non-blank and paste to separate sheet ONLY blank cells (running list)
    By brolsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2014, 03:34 PM
  6. [SOLVED] Macro to fill blank cells in column A based on non-blank cells
    By ktalamantez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2014, 02:47 PM
  7. [SOLVED] Need to merge cells few blank cells based on a value of a cell in the same row
    By skandkamat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2013, 01:33 AM

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