+ Reply to Thread
Results 1 to 8 of 8

Automate selection of value - consolidate values from 2 columns to 1

  1. #1
    Registered User
    Join Date
    01-27-2016
    Location
    Wisconsin
    MS-Off Ver
    2016
    Posts
    11

    Automate selection of value - consolidate values from 2 columns to 1

    Hi-
    I have a macro that does some formatting to a spreadsheet - at the end of this macro, I'd like it to consolidate values into a single column and then delete one of the columns.

    Here is an example of what it looks like


    Before (what I have now)

    A B
    123 --
    456 456
    -- 789
    012 012

    After (what I want after the macro runs)
    A
    123
    456
    789
    012


    There is some rows that have Headers that need to be skipped.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Automate selection of value - consolidate values from 2 columns to 1

    This 012 is asking for the excell file


    Kind regards
    Leo

  3. #3
    Registered User
    Join Date
    01-27-2016
    Location
    Wisconsin
    MS-Off Ver
    2016
    Posts
    11

    Re: Automate selection of value - consolidate values from 2 columns to 1

    Hi Leo - I am not sure what 012 is asking for the excell file means. Can you clarify?

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Automate selection of value - consolidate values from 2 columns to 1

    have to see if it is 012 or '012 or O12


    cheers
    Leo

  5. #5
    Registered User
    Join Date
    01-27-2016
    Location
    Wisconsin
    MS-Off Ver
    2016
    Posts
    11

    Re: Automate selection of value - consolidate values from 2 columns to 1

    '012
    Thank you for your reply.

  6. #6
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Automate selection of value - consolidate values from 2 columns to 1

    You have a macro, @ the end of the macro you want some other result than it give
    best way to get any help from here is to give this file with the macro

    Cheers
    Leo

  7. #7
    Registered User
    Join Date
    01-27-2016
    Location
    Wisconsin
    MS-Off Ver
    2016
    Posts
    11

    Re: Automate selection of value - consolidate values from 2 columns to 1

    Hi Leo-
    Here is a copy of the document
    https://www.dropbox.com/s/zumsnp7mc6...uide.xlsm?dl=0

    I am hoping to merge columns L and M (after the data is copied to the 'Formatted' tab)
    I am hoping to merge columns R and S (after the data is copied to the 'Formatted' tab)

    The existing macro moves the data from one tab to another and formats it.

    Thanks!
    Jesse

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automate selection of value - consolidate values from 2 columns to 1

    Does something like this help?

    Please Login or Register  to view this content.

+ 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] Using VBA to automate copy/paste on new Sheet
    By mdolinger in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-12-2016, 09:18 AM
  2. [SOLVED] VBA copy paste a selection then find the current date and copy this selection row 61
    By woocaro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2015, 11:07 AM
  3. Automate repititive copy and paste
    By Raury in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2014, 12:53 PM
  4. How to automate copy paste
    By alyasch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2013, 09:36 AM
  5. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  6. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  7. Replies: 3
    Last Post: 08-22-2006, 06:10 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