+ Reply to Thread
Results 1 to 9 of 9

Copy and paste data

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    wales
    MS-Off Ver
    Excel 2003
    Posts
    34

    Copy and paste data

    Hi All,

    This code basically copies data from one worksheet to another worksheet based on the date and works great. However, I have been asked to changed the format of the spreadhsete and the code needs to be changed. The code is in ‘This workbook’.

    The code takes the data from the summary tab and copies it to the archive tab. I now need it to take it from the summary tab and copy it to the archive 2 tab.

    Hope this makes sense, I have attached a copy of the spreadsheet.

    Thanks


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

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy and paste data

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-25-2011
    Location
    wales
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Copy and paste data

    Many thanks, when I run the Macro it shows an overflow error

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Copy and paste data

    Try:
    Please Login or Register  to view this content.
    Last edited by millz; 04-24-2014 at 08:46 AM. Reason: Missed out msgbox and sheet select
    多么想要告诉你 我好喜欢你

  5. #5
    Registered User
    Join Date
    10-25-2011
    Location
    wales
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Copy and paste data

    it does work but I will need to add to the spreadsheet so I'm probably not going to be able to adapt this code to fit the new amendments. Is there any way of using the same format as the original code but slightly chnging it. The reason I as is that i can easier amend the original code but will probably not be able to do this on the new code. Sorry for any inconveniance

  6. #6
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Copy and paste data

    I am not sure what problem you may face if you only want to add to the spreadsheet. I've added some comments to help you understand code in the previous post. Hope it helps.

  7. #7
    Registered User
    Join Date
    10-25-2011
    Location
    wales
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Copy and paste data

    thanks millz, I probably explained this really badly. I have uploaded a new spreasheet with new sections added in the summary tab and archive 2 tab (highlighted in green). These also need to be copied over so i need to understand how i can copy these over as well. The spreadsheet is constantly changing so i wll need to make ammendmens as and when. Hope this makes sense
    Attached Files Attached Files

  8. #8
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Copy and paste data

    I see. Here you go:

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    10-25-2011
    Location
    wales
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Copy and paste data

    works like a dream, many thanks

+ 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 formula and paste for new data added and autofill.....and paste special values
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2014, 07:40 AM
  2. Enter data, copy formulas, copy values, paste data, delete data
    By alf40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2013, 07:23 PM
  3. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  4. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  5. Replies: 2
    Last Post: 02-22-2011, 02:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1