+ Reply to Thread
Results 1 to 4 of 4

Copy selected merged rows to new excel sheet

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    175

    Copy selected merged rows to new excel sheet

    I have 190rows in attached excel but 78rows has been selected with merged cell rows but here as its i need to copy the selected rows to new excel sheet how?
    Attached Files Attached Files
    Last edited by maddyrafi1987; 09-04-2019 at 09:08 AM.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,562

    Re: Copy selected merged rows to new excel sheet

    78 Row : Not found any merged cell. Where is merged cell?


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    175

    Re: Copy selected merged rows to new excel sheet

    goto expiry date column and put filter and select only 2019 year and select jan to september and copy the selected rows to new excel how?

    try this correct attached new excel file.
    Attached Files Attached Files

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,562

    Re: Copy selected merged rows to new excel sheet

    Merged cell functionality in Excel is not designed to work with Cut/Copy and Paste. That's because what merged cells are good at is displaying data, not holding data. They are a purely visual thing. If you are using them for any reason other than displaying data to human eyes, remove them.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1