+ Reply to Thread
Results 1 to 8 of 8

copy and Sort data into corresponding month sheets

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    copy and Sort data into corresponding month sheets

    Hi everyone i have a slight problem in a project i am working on.
    Main list sheet is where all data is copied to.
    I have monthly named sheets and these are changed year to year.
    on closing of the sheet i need all the data on main list to be copied into correct months due to date being col A
    but data must remain in main list and only be copied into the others.
    I have been searching the forum for hours but unable to find a solution.
    hope someone can figure this out using Excel 2013
    Also after data copied over, then any fresh data must follow after the last entry not overwrite
    thank you all in advance
    regards Steve
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: copy and Sort data into corresponding month sheets

    Does the new data go at the bottom of the existing or at the top.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: copy and Sort data into corresponding month sheets

    Hi thanks for looking new data gets added to main list sheet after last entry on monthly sheets new data copied over from main list will be added after last entry on month sheets hope this helps
    so on sheet as is new data would be added on line 61 and so on thanks again

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: copy and Sort data into corresponding month sheets

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 01-17-2016 at 06:39 PM.

  5. #5
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: copy and Sort data into corresponding month sheets

    i placed this in a module and ran but didnt work am i placing correctly thanks

  6. #6
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: copy and Sort data into corresponding month sheets

    Apologies it seemed to be working.

    Try this.



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

  7. #7
    Registered User
    Join Date
    05-18-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: copy and Sort data into corresponding month sheets

    Thanks again but still not doing what i need it moves jan feb march april and may dates all into jan and then puts the 10/5/15 in all the other months it doesnt seem to be splitting main list date into the correct sheets in months thank you anyway for your continued support steve

  8. #8
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: copy and Sort data into corresponding month sheets

    Hopefully third time lucky

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

+ 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 data from previous month sheets
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2015, 11:37 AM
  2. Sort and copy data from custom formatted tables on multiple sheets to one area
    By christmaslyric in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2014, 03:14 PM
  3. Copy between sheets if month and year suitable
    By jankas89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2014, 04:25 AM
  4. copy and paste data month to month
    By hotrod4571 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-23-2013, 01:23 PM
  5. Replies: 1
    Last Post: 08-21-2012, 03:14 PM
  6. Unhide sheets, sort sheets and data and rehide
    By pprseller in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-05-2009, 07:18 PM
  7. Pls. reply Sort Data and copy to next coulmn when sort order chang
    By shital shah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 10: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1