Copy/paste values if the cell next to it is empty

  • Is there a way i can copy paste specific rows to the excel ark. The things i need:
    - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book)

    - has to copy the value in the given row if the cell next to it is empty

    - the macro has to be applied from mappe1 (book)

    - next month the may values (which is coming, later at the month) and run it again so it is the may values which copies to mappe1 (book)

    - The workbooks has to be open



    So the point is to always copy paste the lastest value from mappe2 (book) to mappe 1 - month by month.
    In mappe1 there are maybe more variables to come to maybe in two months there has to e3,e4,e9,e13,e15 and add e5 and e14.
    So if I can put more rows in the macro for future months copy paste it would be perfect.

    I really can figure out to make the macro for choosing a value if the next cell is empty and the same when pasting it in mappe1 (book)

    Thank you for the help.


    Photo attached

  • Let me recap ...


    In an Excel Forum ... it is quite a good idea to attach ... well ...guess what ... Excel files ...:)


    Images are dead objects ... totally useless ... :thumbdown::cursing:


    In addition, by attaching you file, you will allow any contributor :

    1. to actually visualize all your constraints ...

    2. to understand your expected result ... and...

    3. to suggest a fully tailor-made solution ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Here is the attached workbooks. My english is not that good, but i tried to tailor a solution as good as I could.

    Files

    • Mappe1.xlsx

      (8.89 kB, downloaded 16 times, last: )
    • Mappe2.xlsx

      (9.32 kB, downloaded 18 times, last: )
  • Quote

    But I just go on with the discussion on Mr.Excel


    Good Luck ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)