Hi all,
I got a question about name manager.
I would like that the name manager auto adds values based on a cell.
See my example file.
I would like that everyone that is in Shift A is added to Shift_A in name manager
Everyone that is in Shift B added to Shift_B
Names are being added and removed to this excel so i can't use name manager as normal with a fixed Range.
Anyone knows if this is possible? And yes, how?
This solution involves helper columns added to a sheet called Lists.
The first three columns give the count per row of the number of people in each shift, corresponding to the Shifts sheet.
Columns E:G use that data to look up the names of the people in each of those three shifts.
The names Shift_A/B/C use those three columns to create dynamic names that are the lists.
Wow, that's brilliant.
Gonna try to understand it a bit more but it looks perfect!
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks