Results 1 to 6 of 6

Merge identical cells in table

Threaded View

YasserKhalil Merge identical cells in table 10-25-2015, 02:36 PM
TMS Re: Merge identical cells in... 10-25-2015, 04:15 PM
YasserKhalil Re: Merge identical cells in... 10-25-2015, 05:32 PM
TMS Re: Merge identical cells in... 10-25-2015, 06:09 PM
LJMetzger Re: Merge identical cells in... 10-25-2015, 08:32 PM
YasserKhalil Re: Merge identical cells in... 10-26-2015, 01:35 AM
  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Merge identical cells in table

    Hello everyone
    I have a sheet named "Basic" ..I need to convert it and merge cells to another table not in the same table ..
    For example : In Sheets("Basic").range("B7:C7") the values are identical (the same so they would be merged
    The merge process to be in the same row (no include column) ... I mean for example B9 and B10 not to be merged although they are the same ...

    Another example: V8 and W8 are to be merged together

    In case there are three identical values just the first two be merged only ...
    for example: G8 - H8 - I8 are the same but just G8 - H8 to be merged and I8 still as it is

    In case there are four identical values : each two to be merged ..not all the cells to be merged

    The desired result should be in the sheet("Merged") not in the same sheet

    Hope it is clear
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-11-2014, 10:12 PM
  2. VBA to merge cells with identical content
    By juangar1992 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2013, 04:05 PM
  3. Replies: 3
    Last Post: 06-04-2013, 01:00 PM
  4. Merge identical Labels in Pie chart
    By Ravnoss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2010, 10:54 AM
  5. merge identical fields and generate totals.
    By apeman1977 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-18-2009, 11:30 AM
  6. Can't paste as merge cells aren't identical
    By Muttley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2006, 11:15 AM
  7. [SOLVED] REQ - Help with merge/delete of duplicate/identical cells
    By Mark in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 08:06 AM

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