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.
Bookmarks