+ Reply to Thread
Results 1 to 10 of 10

Copy column with merged cells to another sheet

  1. #1
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    151

    Copy column with merged cells to another sheet

    Hello

    I have another issue here, how to copy Sheet 2 column D-I from row 13 with merged cells just as it is, to Sheet 1 column A-F row 9

    Or is it another solution,
    Attached Files Attached Files
    Last edited by dodde; 05-24-2020 at 03:55 AM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,291

    Re: Copy column with merged cells to another sheet

    .
    Unmerge the cells.

    Merged cells create more issues than they are worth. Excel does not handle merged cells well.

    Learn to live without them.

  3. #3
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    151

    Re: Copy column with merged cells to another sheet

    Hello

    so there is no way to raw copy and paste

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,291

    Re: Copy column with merged cells to another sheet

    .
    I'll look for a means but ... AVOID MERGED CELLS AT ALL COST. Either in the beginning or somewhere
    down the line, merged cells will create havoc. This is not my opinion .. it is the view of most everyone
    who uses VBA or EXCEL Formulas.

    For example ... copying your current data as is :



    D12 F12 G12 H12 I12
    D13 E13 F13 G13 H13 I13
    D14 E14 F14 G14 H14 I14
    D15 E15 F15 G15 H15 I15
    D16 E16 F16 G16 H16 I16
    D17 E17 F17 G17 H17 I17


    The E12 gets left out.

    Let me look around...

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,291

    Re: Copy column with merged cells to another sheet

    .
    I looked at a dozen or more websites that speak to copying/pasting merged cells.

    They all advise against merged cells to begin with.

    Then they continue on with explaining how you can unmerge the cells before copying and pasting.

    Several went in to great detail discussing why cells should not be used as the data they contain may
    look good to the user but they are a bear to work with via VBA and Formulas.

    So ... no ... I could not locate anything that talks how to copy and paste merged cells.

    Sorry

  6. #6
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    151

    Re: Copy column with merged cells to another sheet

    Hello

    Ok thanks for trying, i will find a way

  7. #7
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,112

    Re: Copy column with merged cells to another sheet

    No 1 priority. Get rid of the merged and merged and center cells as mentioned by Logit.
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Norge
    MS-Off Ver
    2019
    Posts
    151

    Re: Copy column with merged cells to another sheet

    Hello

    Thats work, Thanks

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,291

    Re: Copy column with merged cells to another sheet

    .
    You are welcome.

    Glad to help.

  10. #10
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,112

    Re: Copy column with merged cells to another sheet

    Thanks Logit

+ 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