+ Reply to Thread
Results 1 to 7 of 7

Copy + Paste from multiple worksheets

  1. 08-12-2017, 04:50 PM #1
    AlexShip
    AlexShip is offline
    Registered User
    Join Date
    06-28-2017
    Location
    UK
    MS-Off Ver
    2007
    Posts
    37

    Copy + Paste from multiple worksheets

    Hey guys,

    Wondering if someone can give me a good idea on how to put together a macro that will copy + paste from one worksheet and then paste it into another?

    I've tried to put something together but it doesn't work out the way I want it to and was wondering if there was an easier way around it?

    I want to copy from sheet "Old entries" for A2: O1000 then paste into cell A2 on a spreadsheet called "Cross Referenced".

    I then want to do the same for another worksheet "New Entries" so copy cells A2:01000 and then paste into cell A1000 for worksheet "Cross Referenced".

    Any help for this task would be much appreciated.
    Last edited by AlexShip; 08-12-2017 at 05:01 PM.
    Reply With QuoteRegister To Reply
  2. 08-12-2017, 04:55 PM #2
    JLGWhiz
    JLGWhiz is offline
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Copy + Paste from multiple worksheets

    If you copy from 'Old entries' to A2 of 'Cross Referenced' and then copy from 'New Entries' to A2 of 'Cross Referenced, you will overwrite the data that was copied from 'Old entries'. Would you like to clarify?
    Reply With QuoteRegister To Reply
  3. 08-12-2017, 04:56 PM #3
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Copy + Paste from multiple worksheets

    If you're pasting both lots of data into Cell A2 on "Cross Referenced" won't one overwrite the other?

    BSB
    Reply With QuoteRegister To Reply
  4. 08-12-2017, 05:02 PM #4
    AlexShip
    AlexShip is offline
    Registered User
    Join Date
    06-28-2017
    Location
    UK
    MS-Off Ver
    2007
    Posts
    37

    Re: Copy + Paste from multiple worksheets

    Hey guys,


    I just realised that as soon as I walked away from my computer. Thanks for poitning that out.

    Revised cell would be A1000
    Reply With QuoteRegister To Reply
  5. 08-12-2017, 05:11 PM #5
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Copy + Paste from multiple worksheets

    Copying to A1000 would still overwrite the last row of data. I'm not sure if you need that but the code below will paste to row 1001 on the second paste.
    Please Login or Register  to view this content.
    BSB
    Reply With QuoteRegister To Reply
  6. 08-12-2017, 05:30 PM #6
    AlexShip
    AlexShip is offline
    Registered User
    Join Date
    06-28-2017
    Location
    UK
    MS-Off Ver
    2007
    Posts
    37

    Re: Copy + Paste from multiple worksheets

    Works like a charm.

    Thanks.
    Reply With QuoteRegister To Reply
  7. 08-12-2017, 05:32 PM #7
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Copy + Paste from multiple worksheets

    Happy to help

    BSB
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste in multiple worksheets
    By malesela in forum Excel General
    Replies: 4
    Last Post: 12-26-2013, 09:54 AM
  2. Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets
    By NumberCruncher311 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2013, 08:21 PM
  3. Create, Copy, Paste to multiple Worksheets
    By MSchibs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2011, 05:15 PM
  4. Search, copy and paste across multiple worksheets
    By farkinell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2011, 05:22 AM
  5. Copy from multiple worksheets and paste to new sheet
    By melbri in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2010, 05:23 PM
  6. Excel 2007 : Copy & Paste formulas to multiple Worksheets
    By Karamazov in forum Excel General
    Replies: 3
    Last Post: 08-11-2010, 06:41 AM
  7. Copy and paste btw multiple worksheets while maintaining one value
    By s_hillyard in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-23-2008, 01:39 PM
  8. [SOLVED] copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro
    By Steven in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2005, 04:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1