View Single Post
 
Old 09-20-2015, 04:33 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, but by using multiple sheets, you're actually making it harder. FWIW I recently constructed some workbooks for use by novices for generating monthly rosters and summarising data across a number of activities. All the inputs are done on one sheet and all the reports etc. are generated on other sheets via formulae. This has eliminated both the need to have a separate sheet for each month's roster and the need to transcribe the data from there to the periodic summaries.

In your case, depending on the types of reports needed, a similar outcome could be achieved. Stick with the multiple worksheets, though, and there is no way any of this can be done without macros. And, once you get into macros, you're into the demands of a much higher skill set to develop, use and maintain them. Development would not be possible without access to the workbooks. Mind you, I'm not saying everything you want can be achieved without macros but that your current approach mandates them.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote