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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,562
Messages
5,838,122
Members
430,529
Latest member
PaperBoi5870

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
Top