Results 1 to 5 of 5

VB Code to Create summary schedule by bringing schedule data from different sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-31-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    194

    VB Code to Create summary schedule by bringing schedule data from different sheet

    Hello:

    Please refer to attached file.

    LJ,WE,EL,BN,,etc until TN are the Name of the stores.
    In each of the tab, I will be creating work schedule.

    I need VB Code to do following task.
    Sheet "FullSch" will have list of all Employees.

    I need to go thru each employee and see if he/she is scheduled in any of the
    stores LJ Thru TN.
    If they are then bring and enter the schdeule time and Name of the store in
    the day column C thru I.

    I have manually created 2 employees "Colleen Laird, Linda Pater "information as shown

    Let me know if you have any questions.
    Thanks.

    R
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Create Daily Break Schedule from Weekly Work schedule
    By colema62 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2021, 04:31 PM
  2. Noob here- best approach to extract personal schedule based on an employee schedule sheet,
    By fortnight_skyrim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2018, 01:02 AM
  3. Create a schedule of events from data sheet
    By sipa in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-03-2015, 05:11 PM
  4. Create Individual Schedule from Master Schedule
    By kscheller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2014, 11:47 PM
  5. create daily schedule using master task schedule
    By DCO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 01:08 PM
  6. Shift Schedule - 3 Shift Coverage - Auto Populate Roll-up Summary Schedule
    By chips1256 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-31-2012, 09:32 AM
  7. [SOLVED] Create patient schedule based on master therapist schedule
    By PapaBear in forum Excel General
    Replies: 8
    Last Post: 10-12-2005, 12: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