Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-09-2016, 07:49 AM
lewashby lewashby is offline Many Sheets, One DB Windows 8 Many Sheets, One DB Office 2003
Novice
Many Sheets, One DB
 
Join Date: Feb 2016
Posts: 3
lewashby is on a distinguished road
Default Thanks.

Quote:
Originally Posted by gebobs View Post
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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to manage some sheets and sub-sheets? tesoke Excel 6 11-15-2015 04:54 AM
Many Sheets, One DB Excel sheets ubns Excel 4 04-15-2012 10:48 PM
Copying sheets DavidSNPCPA Excel 2 01-19-2012 03:54 AM
Balance from different sheets andre Excel 0 11-29-2011 02:36 PM
Linking sheets to fetch transactions from sheets to another waqer Excel 4 09-01-2011 12:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft