Hello All
just wondering if a kind soul could point me in the right direction with my enquiry.
Using XL 2013, I'm trying to combine various information into a worksheet which will act as a dashboard to display information from various other workbooks and website feeds. Most of it is quite simple stuff and I have found this site to be very helpful, but something is eluding me, if it is even possible - I;'ve tried pivot tables, so guess Im doin it wrong or VBA is the way forward.
One of the workbooks to be referenced contains a monthly worksheet schedule for 40 staff, and shows amonsgt other things whether they are working an early shift, late shift or rest day.
This is the information that I need to extract and display each day as a list on the dashboard page,
ie persons name in a table, for Early shift or Late shift. The data will obviously change on a daily basis.
I have a helper table to combine each monthly worksheet into a worksheet covering the entire year.
Column A contains their name - 1 row per staff member(40 rows)
Column B (and the next 366 columns) contains the date as a header, along with relevant shift type against staff member on the corresponding rows / columns
How would you set about extracting only the names of staff working an early shift and those working a late shift, so that the data can be displayed in 2 seperate lists on the dashboard?
Grateful for any pointers
Sean
just wondering if a kind soul could point me in the right direction with my enquiry.
Using XL 2013, I'm trying to combine various information into a worksheet which will act as a dashboard to display information from various other workbooks and website feeds. Most of it is quite simple stuff and I have found this site to be very helpful, but something is eluding me, if it is even possible - I;'ve tried pivot tables, so guess Im doin it wrong or VBA is the way forward.
One of the workbooks to be referenced contains a monthly worksheet schedule for 40 staff, and shows amonsgt other things whether they are working an early shift, late shift or rest day.
This is the information that I need to extract and display each day as a list on the dashboard page,
ie persons name in a table, for Early shift or Late shift. The data will obviously change on a daily basis.
I have a helper table to combine each monthly worksheet into a worksheet covering the entire year.
Column A contains their name - 1 row per staff member(40 rows)
Column B (and the next 366 columns) contains the date as a header, along with relevant shift type against staff member on the corresponding rows / columns
How would you set about extracting only the names of staff working an early shift and those working a late shift, so that the data can be displayed in 2 seperate lists on the dashboard?
Grateful for any pointers
Sean
