+ Reply to Thread
Results 1 to 1 of 1

Sorting data between un-merge and merge

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    FL
    MS-Off Ver
    Excel 2013
    Posts
    123

    Sorting data between un-merge and merge

    Hello,

    I have been working on this for over a week now and feel like I'm banging my head on the wall.

    I have a report that has tons of Merged cells. This report needs to be sent to Clients so it must be formatted and look a certain way. The problem is that our reporting software does not spit out the data in a way that is pleasing to our clients. I need to unmerge cells sort then re merge the cells. I have tried numerous ways and always run into issues.

    I can handle all the formatting and borders and making it look pretty. however afterIi unmerge the cells and sort from oldest to newest i can never get a macro to merge the cells back the way they should.

    I think it may be possible to seperate everything with a row full of 1's

    I know Merging cells with macro's is a pain and unadvised which is why I have been at this for over a week. If someone could help solve this piece of the puzzle i think i may have it finished.
    Attached Files Attached Files
    Last edited by kleptilian; 03-12-2015 at 04:32 PM.

+ 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: 0
    Last Post: 04-21-2006, 03:40 PM
  2. Merge files & sorting data
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  3. Merge files & sorting data
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  4. Merge files & sorting data
    By GRAHAM MASON in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. Merge files & sorting data
    By GRAHAM MASON in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2005, 04: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