Rosters

Matome

New Member
Joined
May 30, 2015
Messages
1
Hey Guys, newbie here....

Not even sure what you'd call what I'm trying to achieve, so will try to describe...

I have a Roster sheet - and 5 daily operating plans on 5 separate sheets (Mon to Fri).

The Roster sheet currently draws information (via the formulas) from the Monday daily operating plan (DOP) sheet only. However, I want the data in the Roster sheet to change according to the day selected by the user from a drop down list. I have created the drop down list by creating and index sheet and using data validation.

So my question is, how do I get all the data in the Roster sheet to refer to and draw data from different DOP days of the week according to the day selected from the drop down list?

Would add a picture but can't work out how to include it...

Thanks in advance for any help.

Josh
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hey Guys, newbie here....


Would add a picture but can't work out how to include it...

Thanks in advance for any help.

Josh

You can post a link to a sample workbook, I use Drop Box, but there are others.

Include exactly what you want to happen and on what sheet and what cells. Sometimes a manually typed in result to demo what you want is good with a notation as such.

Howard
 
Upvote 0

Forum statistics

Threads
1,217,322
Messages
6,135,897
Members
449,967
Latest member
tobysimon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top