Results 1 to 4 of 4

Thread: Copy and Paste From One Workbook To Another
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copy and Paste From One Workbook To Another

    Hello,

    I have two separate workbooks - nearly identical - that I would like to copy the information from one cell and paste it into another cell within a different workbook.

    So, for example:

    Copy cell A1 from sheet 'Numbers' in workbook titled 2018 and paste it into workbook titled 2019, sheet 'Numbers' and cell A156
    &
    Copy cell A14 from sheet 'Letters' in workbook titled 2018 and paste it into workbook titled 2019, sheet 'Letters' and cell A186


    Thank you in advance for your help.

  2. #2
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,820
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Copy and Paste From One Workbook To Another

    Try this:
    I did the first request.
    You should see how I did this and you should be able to do the second part.
    Both Workbooks must be open
    Code:
    Sub Copy_Data()
    'Modified  8/8/2019  2:17:08 PM  EDT
    Workbooks("2018.xlsm").Sheets("Numbers").Range("A1").Copy Workbooks("2019.xlsm").Sheets("Numbers").Range("A156")
    End Sub
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  3. #3
    New Member
    Join Date
    Aug 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copy and Paste From One Workbook To Another

    I had some new developments...

    The 2018 workbook has 100+ tabs.

    So, I have created a 2019 workbook that has the same number of tabs with the same titles as 2018.

    I would like to copy multiple cells from 2018 (A4, B18, C86, C88 & D1) and paste them into a different cell (A4 in 2018 gets pasted into A5 in 2019, etc.) in the corresponding tab in the 2019 workbook.

  4. #4
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,820
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Copy and Paste From One Workbook To Another

    I suggest you start a new posting.
    Quote Originally Posted by rbellavance22 View Post
    I had some new developments...

    The 2018 workbook has 100+ tabs.

    So, I have created a 2019 workbook that has the same number of tabs with the same titles as 2018.

    I would like to copy multiple cells from 2018 (A4, B18, C86, C88 & D1) and paste them into a different cell (A4 in 2018 gets pasted into A5 in 2019, etc.) in the corresponding tab in the 2019 workbook.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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