Results 1 to 6 of 6

Macro to conanceate three cols.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2017
    Location
    New Zealand
    MS-Off Ver
    Ms Office 2016
    Posts
    455

    Smile Macro to conanceate three cols.

    Hello all,
    I am wanting to get a simple macro that can give me the results I have in col CE.

    The function in col CE is conanceating cols BJ, BK, and col BL only.
    I have 16,276 rows to result.

    The data starts in col BJ and moves right, if col BK contains data then col BJ will never be blank. If col BL contains data, then cols BJ and BK will never be blank.
    There will be blank cells in all three cols, so result is the same as example.

    The data contains numbers and text only.

    Thanks.
    Attached Files Attached Files
    I am grateful for all answers to my questions .
    Also i give a reputation even if not answered .

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro copy data from cols in Source CSV File into specific Cols in destination file
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-13-2023, 06:07 AM
  2. [SOLVED] Times will not conanceate .
    By I need excel help in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2019, 05:48 PM
  3. [SOLVED] Conanceate this simple function to macro .
    By I need excel help in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2019, 01:23 PM
  4. [SOLVED] Sum columns (duplicates in row header) & delete duplicate cols to leave single unique cols
    By kinrossfarm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 05:50 AM
  5. Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error?
    By Craigm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2006, 06:04 AM
  6. [SOLVED] Cond Format:re color 2 cols, skip 2 cols
    By kk in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  7. [SOLVED] Cond Format:re color 2 cols, skip 2 cols
    By Tat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-22-2005, 02:05 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