Rolling Monthly Roster linked to In or Out Occupancy

Bendeguz

New Member
Joined
Apr 20, 2019
Messages
1
Hi, I wonder if anyone can kindly help us on this issue?

We have a Monthly Camp Roster Sheet, [R] = resident in camp / [Out] = resident left / and [In] = resident returned.
However, our second sheet (the one we need linked), is occupancy in the room, which shows; 1 = resident in / or 0 = resident out.
How can we link this from the Roster sheet, so that any time during the month when she/he is [R or In] - it shows as [1] on the occupancy Sheet? But when the roster sheet has an [OUT] in the cell the occupancy shows a zero?

If Jim has 16 days as [R] on the rosters sheet, it should always shown as [1] on the occupancy sheet. As soon as Bill leaves and we input [OUT], automatically the occupancy cell should change to [0] and so on when he returns.
smile.gif

Would really appreciate guidance and help on this thank you so much.
smile.gif
smile.gif

 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

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