Results 1 to 6 of 6

Thread: How to copy and paste data from one worksheet into a new worksheet in same w-book

  1. #1
    Seeker matrix's Avatar
    Join Date
    Dec 2019
    Posts
    15
    Articles
    0
    Excel Version
    2019

    How to copy and paste data from one worksheet into a new worksheet in same w-book



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Excel World...

    I have a problem. I don't know if you can help me. I just don't know.

    How to copy and paste data from one worksheet into a new worksheet in the same workbook. "Keeping all formula, drop-down menu and color codes the same which are link with other worksheets of the same workbook".

    Currently I have 30 worksheets that have the same data layout. However, I would like to create a new worksheet to copy all 30 worksheet ranges from column A, B, C, D, E & F. and paste into new worksheet.

    Please note. I have tried copy and paste, cut and paste and have not worked.

    How can I fix this issue?

    Thanks in advance

    Cheers

    https://drive.google.com/file/d/1lcp...ew?usp=sharing

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    252
    Articles
    0
    Excel Version
    2007
    .
    Some of your cells are merged and are causing issues with the copy / paste process.

    You'll need to find a method of not using merged cells.

  3. #3
    Seeker matrix's Avatar
    Join Date
    Dec 2019
    Posts
    15
    Articles
    0
    Excel Version
    2019
    Thanks Logit for your reply. you mention that some of the cells are merge... what do you suggest I do to fix this problem? As the data is to many to fix in one go...

  4. #4
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    252
    Articles
    0
    Excel Version
    2007
    You'll need to unmerge those cell in the range to be copied.

    In other words .. Columns A:F should not have any merged cells.

    Understandably this will require some manual effort on your part to undo the merged cells on all sheets in range A:F

    It is best practice to avoid merged cells at all cost. In one way or another, merged cells will create an issue at some point.

  5. #5
    Seeker matrix's Avatar
    Join Date
    Dec 2019
    Posts
    15
    Articles
    0
    Excel Version
    2019
    Logit. I have followed your recommendation and it works wonderful.

    Simple things goes a long way...

    Thanks

  6. #6
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    252
    Articles
    0
    Excel Version
    2007
    Glad you have an answer.

    You are welcome.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •