+ Reply to Thread
Results 1 to 6 of 6

Copy from master sheet to sub sheets based on date

  1. #1
    Registered User
    Join Date
    04-09-2014
    Location
    Grand Prairie, TX
    MS-Off Ver
    Excel 2010
    Posts
    7

    Copy from master sheet to sub sheets based on date

    I am trying to automate a copy process. The master sheet in the Excel file is a daily log that I need to report detail from Monthly and Quarterly. I need data to copy each row to appropriate Monthly tab based on picking up the month from the detail keyed in to column K in master sheet. Master sheet is titled Master Tab and the monthly sheets are titled Jan '14, Feb '14.... The current format of the date in Column K is x/xx/xx. All data that is keyed into Columns A thru P need to copy to new row in appropriate month tab. I have very little background in writing the code. Can anyone help me please? Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Copy from master sheet to sub sheets based on date

    Hi, Welcome to the forum

    I'll be happy to help.
    However, would it be possible to desensitize a sample workbook and upload it so that I can see the structures in the sheets and be able to code it more accurately and easily. TX

    To upload a file, click on the Go Advanced button on the bottom right and use the advanced posing window. Click the little paperclip toolbar button to broese and upload the file.

    TX
    Regards,
    Rudi

  3. #3
    Registered User
    Join Date
    04-09-2014
    Location
    Grand Prairie, TX
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Copy from master sheet to sub sheets based on date

    QAR 2014 test file.xls

    I hope I have attached the sample correctly.
    Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Copy from master sheet to sub sheets based on date

    Will look into this this evening....

  5. #5
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Copy from master sheet to sub sheets based on date

    Hi,

    Sorry for the delay. Attached is the workbook that includes the macro although I added the macro code below too.
    Please test and see if it is working OK.
    TX


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

  6. #6
    Registered User
    Join Date
    04-09-2014
    Location
    Grand Prairie, TX
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Copy from master sheet to sub sheets based on date

    Thank you so much, I appreciate your help. I moved additional live data into the file, and ran the macro, I received a run time error of 13. The information that was highlighted in yellow is:
    sM = Month(rSrc.Cells(lV).Value)

    Do you know what might cause this?

  7. #7
    Registered User
    Join Date
    04-09-2014
    Location
    Grand Prairie, TX
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Copy from master sheet to sub sheets based on date

    One other question, will this macro duplicate entries already copied if ran more than once? Any way to not duplicate?
    Thank you

+ 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 Rows From Two Sheets Into Master Based On Criteria
    By longstrider in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-28-2012, 05:17 PM
  2. Copy rows from master sheet to other sheets based on criteria
    By spikeysas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2011, 04:28 AM
  3. Replies: 5
    Last Post: 01-06-2011, 09:29 AM
  4. copy cells from sheets based on date, paste to another sheet
    By upod in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-27-2009, 01:29 PM
  5. Create sheets based on a column of master sheet
    By samdaddy07 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2009, 02:54 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