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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,738
Messages
5,638,093
Members
417,005
Latest member
soso2727

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