Results 1 to 7 of 7

Creating a Daily View from a weekly schedule - move data from one sheet to another by date

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-03-2020
    Location
    Wisconsin
    MS-Off Ver
    365
    Posts
    150

    Creating a Daily View from a weekly schedule - move data from one sheet to another by date

    Hello. I'm looking for some help moving data from one sheet to another based on a specific date. I did post this in the regular forum and someone mentioned an indirect formula, however the more I look at this and because I need this to work with sheets that haven't been created yet, I think a command button would work better?

    Here is my situation. I have a "blending schedule" There are 8 blenders, and each blender runs a different amount of jobs per week. You can see this on this week's tab "10.11" Then, on the right side of the schedule is a daily tracker if you well - It shows what quantity of a job will run on which day. So if we just look at blender 1, you can see that the first job will run on Monday, the 2nd and 3rd will run on Tuesday, the 4th on Wednesday etc... And all 8 blenders will have a schedule like this.

    What I am trying to do, is take the data from whatever jobs from each blender that is running "Today" and move them over into the "Today" worksheet. So if we assume today is Mon 10/11, then when I click my button the first job from blender 1 will move over from the 10.11 tab to the Today tab under blender one. But only the first job because that is all that is running today. And then also the first 5 jobs on blender 2 would also move over to the "Today" tab because those are also schedule on Mon 10/11 - and this would be the case for each subsequent blender. But ONLY if the jobs are scheduled "today"

    Thank you in advance for your help, and let me know if you need any more info. I will be checking back on this all day.
    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. Replies: 0
    Last Post: 03-11-2020, 01:45 PM
  3. [SOLVED] Weekly schedule data to daily schedule
    By Sarah_L in forum Excel General
    Replies: 6
    Last Post: 09-16-2019, 04:36 AM
  4. Macro or Formula needed to summarize Daily Tasks into Weekly Schedule
    By diablo00124 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2015, 07:06 PM
  5. Macro or Formula needed to summarize Daily Tasks into Weekly Schedule
    By diablo00124 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2015, 09:17 PM
  6. Macro or Formula needed to summarize Daily Tasks into Weekly Schedule
    By diablo00124 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2015, 01:44 PM
  7. Replies: 0
    Last Post: 02-07-2014, 10:34 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