Realjoshtodd
New Member
- Joined
- Sep 26, 2017
- Messages
- 34
https://www.dropbox.com/s/ro4aftz437...2018.xlsm?dl=0
I'm trying to build a code that does the following when button is clicked....
- Enter Date (Value) into Cell's B2, C2, D2, E2 on "Daily Alignment" Sheet.
- Import from "Deputy Availability" sheet all of the people who are scheduled to work on those matching days.
- To me this should be matching the value from those cells (B2, C2, D2, E2) in "Daily Alignment" to the values in row 2 on "Deputy Availability" Then having it return all of the values from that matching column, along with the matching name from column b in the same sheet.
Then want it to custom sort the list by say, (Days, E Swings, L Swings, Lates, D CTRL, N CTRL, and any other value listed at end (and whatever else I might have to add).
I'm trying to build a code that does the following when button is clicked....
- Enter Date (Value) into Cell's B2, C2, D2, E2 on "Daily Alignment" Sheet.
- Import from "Deputy Availability" sheet all of the people who are scheduled to work on those matching days.
- To me this should be matching the value from those cells (B2, C2, D2, E2) in "Daily Alignment" to the values in row 2 on "Deputy Availability" Then having it return all of the values from that matching column, along with the matching name from column b in the same sheet.
Then want it to custom sort the list by say, (Days, E Swings, L Swings, Lates, D CTRL, N CTRL, and any other value listed at end (and whatever else I might have to add).
