"Barb Reinhardt" wrote in message
...
What exactly do you hope to gain by having 365 sheets that a one worksheet
(or maybe 12) couldn't accomplish with some pivot tables?
--

Hmmm, I skimmed over some material regarding pivot tables and they mostly
seem to be used for analyzing sets of data??? Is that right??


Right now, our company saves daily work transactions into individual
spreadsheet files.
Therefore, at the end of 1 year, our directory will have accumalted 365
separate files,
which is not terribly bad.

However, I just got to thinking....could it be possible to efficiently store
a year's worth of
work in a SINGLE Excel file, smartly and efficiently?? Ideally, I would
like to be able
to create a drop down list box that allows the user to select the current
date. Once the
current date is selected, I want Excel to load the worksheet for that day.
Is something
like this possible?? Do I need to use Visual Basic?? Or is this still
something that
pivot tables could solve??

Thank you for your help Barb!