Engine1911
New Member
- Joined
- Oct 6, 2018
- Messages
- 3
Hi all,
First time posting. So I am creating a manpower document for our firehouse. The simple explanation of it is, one master sheet that has everyone's names in column A ad monthly dates in rowA A . At the intersections are drop down menus with specific values to designate on shift, off shift, overtime, leave, etc.. Then I have individual sheets for each day of the month which pull data from the master sheet and assign personnel accordingly. Currently I have a macro that will search for a value from a designated cell (example "T") and list the names in the cells I have assigned in descending order. What I am looking for is the ability to also have it return names that have other values such as "OT" or "TT". Is this possible? Here is the macro I am currently using:
=IF(ISERROR(INDEX(Master!$B$6:$B$78,SMALL(IF(Master!$C$6:$C$78=Master!$AI$2,ROW(Master!$C$6:$C$78)),ROW(1:1))-5)),"",INDEX(Master!$B$6:$B$78,SMALL(IF(Master!$C$6:$C$78=Master!$AI$2,ROW(Master!$C$6:$C$78)),ROW(1:1))-5))
First time posting. So I am creating a manpower document for our firehouse. The simple explanation of it is, one master sheet that has everyone's names in column A ad monthly dates in rowA A . At the intersections are drop down menus with specific values to designate on shift, off shift, overtime, leave, etc.. Then I have individual sheets for each day of the month which pull data from the master sheet and assign personnel accordingly. Currently I have a macro that will search for a value from a designated cell (example "T") and list the names in the cells I have assigned in descending order. What I am looking for is the ability to also have it return names that have other values such as "OT" or "TT". Is this possible? Here is the macro I am currently using:
=IF(ISERROR(INDEX(Master!$B$6:$B$78,SMALL(IF(Master!$C$6:$C$78=Master!$AI$2,ROW(Master!$C$6:$C$78)),ROW(1:1))-5)),"",INDEX(Master!$B$6:$B$78,SMALL(IF(Master!$C$6:$C$78=Master!$AI$2,ROW(Master!$C$6:$C$78)),ROW(1:1))-5))
