+ Reply to Thread
Results 1 to 6 of 6

Copy & Paste from Sheet1 to Sheet2

  1. #1
    Registered User
    Join Date
    11-02-2017
    Location
    Bucharest
    MS-Off Ver
    2016
    Posts
    49

    Copy & Paste from Sheet1 to Sheet2

    Good morning!

    Can somebody solve this problem for me ? I have the code but is missing something. I want from everytime i use the macro button, the new data to paste it under the previous one.. I mean if data is on A1, the next one to be in A2, A3, etc...

    "Worksheets("Sheet2").Range("A1").Value = Worksheets("Sheet1").Range("A1").Value"

    This code only replace the previous one.. I want to keep it the previous and the new data to go on A2, A3, etc...

    Thank you and have a nice day!

  2. #2
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    968

    Re: Copy & Paste from Sheet1 to Sheet2

    Hello Spikyd,

    Try the code as follows:-

    Please Login or Register  to view this content.
    I am assuming that you do not have a heading in Sheet2, A1.
    I am also assuming that you are only ever transferring the value from Sheet1, A1.

    I hope that this helps.

    Cheerio,
    vcoolio.

  3. #3
    Registered User
    Join Date
    11-02-2017
    Location
    Bucharest
    MS-Off Ver
    2016
    Posts
    49

    Re: Copy & Paste from Sheet1 to Sheet2

    Object required... Error 424
    I'm using MO 2016

  4. #4
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    968

    Re: Copy & Paste from Sheet1 to Sheet2

    Hi Spikyd,

    I would say that you are getting the error on this line:-

    Please Login or Register  to view this content.
    so change it to:-

    Please Login or Register  to view this content.
    which should match the rest of your code.

    Cheerio,
    vcoolio.

  5. #5
    Registered User
    Join Date
    11-02-2017
    Location
    Bucharest
    MS-Off Ver
    2016
    Posts
    49

    Re: Copy & Paste from Sheet1 to Sheet2

    Is working now! Thank you very much!

  6. #6
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    968

    Re: Copy & Paste from Sheet1 to Sheet2

    You're welcome Spikyd.
    I'm glad that I was able to help.

    Cheerio,
    vcoolio.

+ 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. Copy/Paste Data from Sheet1 to Sheet2
    By h.noor in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-11-2015, 11:39 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] copy paste value from sheet1 to sheet2 in empty cell only
    By koi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2013, 03:46 AM
  4. [SOLVED] Copy data from column A and B Sheet1 and paste into Sheet2
    By rabra in forum Excel General
    Replies: 2
    Last Post: 02-03-2013, 11:39 AM
  5. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  6. Copy 3 cells from sheet1 then paste to sheet2
    By Christeen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-10-2011, 09:16 AM
  7. Copy cells sheet1, paste to sheet2
    By Flintstone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2005, 04:21 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