Quote:
Originally Posted by gebobs
As for separating by units, since each inmate can only have one unit (I presume), that could easily be handled on the same sheet by adding a field for unit and filtering. I know you want separate sheets for this but I only suggest this because I'm a stickler for avoiding data duplication.
However, I'm not sure that is the case for your staffing situation. Would each inmate have many staff? If that's the case, then I think you are forced to use multiple sheets. That in turn would, I think, need code, if it can be done at all in Excel. If you prefer to go that route, maybe repost in the programming section. My VBA skills are rusty and were more with Access any way.
And, speaking of Access, if it is a many-to-many relationship, a relational database might be a better platform, though I know Access has fallen out of favor of late.
However, if there's any chance you think the one sheet/filtering option might work, I'll be glad to help.
|
Sorry it took so long for me to get back to your reply. The filtering thing might work perfectly and I see only one possible problem with it. When I print out the sheets because the inmates have to sign by their names, I print them of in a range based on the units on the compound. So I have one sheet that has all the inmates for units 1-16, another for units 17-20, 21, 22 + 23, 24 + 25 and one last on for unit 28 (26 & 27 don't exist yet). Each of these sheets has a few rows for a heading describing which units its for and a head header cell for each column. If I use the filtering technique your are describing will I be able to print the sheets out with different heading cells? Thanks again.