+ Reply to Thread
Results 1 to 1 of 1

Merge Rows Depending on List Criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    12-13-2017
    Location
    Cork Ireland
    MS-Off Ver
    2016
    Posts
    1

    Question Merge Rows Depending on List Criteria

    Hi,

    Basically In column B I have a list option. If I pick a certain one I want it the spreadsheet to merge a certain amount of cells. Ie 2x. Then Column A row 5 &6 will merge.

    If they pick a different option on the list it will merge with a different amount. I.e. 4x+_ then merge with the below 4 rows.

    See attachment's for example.
    Attached Images Attached Images
    Last edited by eharri27; 12-13-2017 at 11:07 AM.

+ 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. returning last 3 rows depending on cell criteria
    By sfoll in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-26-2015, 11:21 AM
  2. returning last 3 rows depending on cell criteria
    By sfoll in forum Excel General
    Replies: 7
    Last Post: 08-24-2015, 08:39 AM
  3. Replies: 1
    Last Post: 01-06-2013, 04:50 AM
  4. [SOLVED] Need help to get info from different columns & rows depending on criteria
    By abqr1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2012, 01:44 PM
  5. VBA Code to Cut and Paste rows of data depending on criteria
    By Erik88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2011, 03:03 PM
  6. Merge rows depending on the value of the first column
    By sp123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2006, 02:57 PM
  7. Merge Rows depending on value of the first column
    By sp123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 10:50 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