+ Reply to Thread
Results 1 to 14 of 14

paste between 2 sheets

  1. #1
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    paste between 2 sheets

    Hi in the sheet attached:
    if the values in column E6:E change less than 11
    paste the row into the ORDINARE sheet in progression
    xam
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry in column E and press the RETURN key.
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    Re: paste between 2 sheets

    Hi munphs1 your macro works in workbook alone
    Now I inserted your macro in my macro but it does not paste the data in the "AGGIORNA" sheet

    Please Login or Register  to view this content.
    must paste only the columns A / B / C / D / E / F of the sheet "articoli"
    Attached Files Attached Files

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    Change to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    Re: paste between 2 sheets

    Where is it

    Range("A" & Target.Row).Resize(, 6).Copy

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    Re: paste between 2 sheets

    Hi munphs1 your macro works in workbook alone


    Now I inserted your macro in my macro but it does not paste the data in the "AGGIORNA" sheet

    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    This line of code:
    Please Login or Register  to view this content.
    checks to see if the target is in column F or column G. When you change a value in column E, it does not meet the requirements of the line of code above. Because of this, the code skips all the way down to
    Please Login or Register  to view this content.
    which is the second last line in your code. This means that the code I suggested is skipped and will never run.

  9. #9
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    Re: paste between 2 sheets

    I have edit in my macro so:

    Please Login or Register  to view this content.
    now works
    only need to change paste without formatting and formulae
    Attached Files Attached Files
    Last edited by xam99; 02-09-2020 at 10:13 AM.

  10. #10
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    Try:
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    Re: paste between 2 sheets

    Work well

    Please Login or Register  to view this content.
    is it possible to add just another column?

    Range("A" & Target.Row).Resize(, 5) + only column 10

  12. #12
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    Try:
    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    437

    Re: paste between 2 sheets

    Hi mumphs1 work well
    in your macro little error

    Range("J" & Target.Row).Copy


    Please Login or Register  to view this content.
    a greeting and many thanks.
    xam

  14. #14
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,775

    Re: paste between 2 sheets

    You are very welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. paste values between sheets
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2019, 02:16 PM
  2. Create Sheets, separate records, copy-paste cell values from master to created sheets
    By hishamezzat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2018, 05:31 PM
  3. [SOLVED] Copy Paste From Rawdata Sheets to Multiple Sheets Based on Sheet names
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 11:01 PM
  4. cut and paste and navigating betwwen sheets and deleting extra sheets
    By bmbalamurali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2014, 01:13 PM
  5. Cut and Paste to different sheets based on value.
    By bopsgtir in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 11:30 AM
  6. [SOLVED] copy and paste values of all sheets into new sheets
    By greatjobtoday in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2012, 01:44 PM
  7. Cut and paste across sheets
    By gigz42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2011, 03:45 PM

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