Cell data of One Sheet Select Automatically copies in a cell of Other Sheet.

  • Sorry, my misunderstanding.


    Change the code to this

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Dear Kjbox,

    What is this line means

    Code
    1. .Resize(100).ClearContents

    This line gives me an error in my workbook but not in your sample workbook.

    But if I remove the above code It copies data but after another selection, previous data remain.

    So this line of code clears the data to the destination sheet (Number).

    my destination sheet (Number) has 6 cells from D9:D14.


    Will you explain what should I have to do about this error.


    Thank you.

  • That clears any data from a previous copy paste. It clears 100 rows (D9 to D108). I had no way of knowing how many entries there might be so I reckoned 100 would be more that enough.


    So change that to

    Code
    1. .Resize(6).ClearContents

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • That is the reason then. Merged cells are a headache in waiting! They should be avoided whenever possible, and never be in data tables.


    If you have to have merged cells can you attach an example workbook with identical merged cells

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Also what is being copied? Numbers, short text or long text?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Dear KjBox,


    Should I ask same type of query in this thread?


    If ok Then read it Otherwise ignore it.


    "Search and copy-paste"


    Two worksheets, Bill and Support

    Four cells in worksheet "Support" (Cells are I20, M20, R20, T20)

    Four-column in worksheet "Bill" ( I, W, X Y) which start from 9 -1220


    If the command button is clicked.


    I20 value of "support" search in between I9:I1220 of Bill Worksheet.

    If match found then M20, R20, and T20 Value paste in the corresponding row of W, X, Y.

    and give a massage "value updated"


    Hope you help me.


    Thanks in advance.