+ Reply to Thread
Results 1 to 3 of 3

Merged and unmerged cells based on value in a cell

  1. 04-06-2013, 08:49 AM #1
    Rocky2013
    Rocky2013 is offline
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Merged and unmerged cells based on value in a cell

    Hi,
    I try to unmerge cells A1:A5 based on a value "unmerged" in cell G1.

    Also if I select "merged" in cell G1 (data validation), then cells A1 to E1 will merge to a single cell A1.

    Thanks
    Attached Files Attached Files
    Last edited by Rocky2013; 04-06-2013 at 03:27 PM.
    Reply With QuoteRegister To Reply
  2. 04-06-2013, 09:00 AM #2
    Careless
    Careless is offline
    Registered User
    Join Date
    03-24-2013
    Location
    Earth
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    81

    Re: Merged and unmerged cells based on value in a cell

    use vba code , could be do that
    are you ensure when choose merged , all cells of A1:E1 will lost but a1 cell value will save or else processed data method ?
    Attached Files Attached Files
    Last edited by Careless; 04-06-2013 at 09:11 AM. Reason: add attachment demo
    Reply With QuoteRegister To Reply
  3. 04-06-2013, 03:27 PM #3
    Rocky2013
    Rocky2013 is offline
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Merged and unmerged cells based on value in a cell

    Thaks! That is what I need.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1