+ Reply to Thread
Results 1 to 2 of 2

Macro to Remove Colors and Create Individual Workbook

  1. #1
    Registered User
    Join Date
    04-16-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    57

    Macro to Remove Colors and Create Individual Workbook

    There are 2 sheets - Summary and Report.

    Report sheet contains a template.

    After the summary is generated, staff works on it and a report is maintained in the template.

    Since the volume of the report is huge, the work is allocated between the staffs by highlighting in colors.

    Some notes are also maintained in columns S, T, U, V and W.

    Macro should create an individual workbook from the template.

    The newly created workbook should not contain any colors and notes.

    This workbook and the worksheet should be named as Weekly_Report_20Apr

    Since the name contains date, macro should name the workbook on dates when it is run.

    Ex:

    If it runs on 21 Apr macro should name the workbook and worksheet as Weekly_Report_21Apr
    If it runs on 01 My macro should name the workbook and worksheet as Weekly_Report_01May

    Note :

    No changes should be done on the template, in other words the template should reflect colors and notes
    whereas the individual workbook should not reflect colors and notes

    Sample sheet attached, report sheet has some explanation
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Macro to Remove Colors and Create Individual Workbook

    You seem to be giving us a specification for work you want done, rather than asking a question to get help. If you are looking for someone to do a project for you then please consider our Commercial Services forum, where you can offer payment for custom services.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Replies: 3
    Last Post: 12-22-2014, 09:14 PM
  2. How do I create a macro that will split my spreadsheet into individual files?
    By DJ3679 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2014, 07:02 PM
  3. How do I create a macro that will split my spreadsheet into individual files?
    By DJ3679 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2014, 03:20 PM
  4. Macro to input data from individual workbook to Master workbook
    By garfield0304 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 07:42 PM
  5. Macro to create individual reports off of a Master Workbook
    By DotWFM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 01:10 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