Mike Davis 1977
New Member
- Joined
- Dec 1, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
i have a problem not even sure it can be fixed
i have a large (ish) workbook i use for scheduling tasks to multiple engineers across the weeks
Each Tab in book is 1 week and then Engineers Down Left Side and Days Of the week across the top (image of 1 week is uploaded to show this
what i require if possible is a VBA code that will pull Specific data from each Tab onto 1 New Tab to Show Tasks that Fail.
you will see in the image that each set of cells showing 1 task has a Status (drop down) "Not Started, Complete, Failed, Rolled" depending on the status at the end of each day
the Failed Tasks are the ones i need to have a Auto List Created as the Office Staff cannot Keep this up to date (to much work apparently)
1, is this possible?
2, can anyone assist me with this ?
in the Image you can see 1 Gang For the Week directly below this is the same Cell Layout Repeated another 8 times as i have 8 gangs to Field Daily
Any Further Info you Need to assist with my Query please ask and ill do my best to reply swiftly
i have a large (ish) workbook i use for scheduling tasks to multiple engineers across the weeks
Each Tab in book is 1 week and then Engineers Down Left Side and Days Of the week across the top (image of 1 week is uploaded to show this
what i require if possible is a VBA code that will pull Specific data from each Tab onto 1 New Tab to Show Tasks that Fail.
you will see in the image that each set of cells showing 1 task has a Status (drop down) "Not Started, Complete, Failed, Rolled" depending on the status at the end of each day
the Failed Tasks are the ones i need to have a Auto List Created as the Office Staff cannot Keep this up to date (to much work apparently)
1, is this possible?
2, can anyone assist me with this ?
in the Image you can see 1 Gang For the Week directly below this is the same Cell Layout Repeated another 8 times as i have 8 gangs to Field Daily
Any Further Info you Need to assist with my Query please ask and ill do my best to reply swiftly