"BotRot" wrote in message
...


How many rows? If the number of rows are arbitrary, would you exceed 20
rows?
1000 rows?
Are you able to re-arrange the row-column structure of your data to reduce
the
rows?


Each day will contain anywhere from 1 to 25 business transactions. Data for
each
transaction will be saved in its own unique row (which has 13 columns).


To respond on "face value" for your question, yes. Having more than one
day, or
as many days
of data that will easily fit on one Worksheet, and if the data need to be
referenced, you can encapsulate
the daily data within a named range.

- or -

Set your columns, and fill down the rows with one column representing
date.

- or -

Use Access?

I worked for one company that just placed one day of data, on one
Worksheet, in
one Workbook, and saw
that it takes many workbooks make up a year, but it worked (well) for
their
purposes.


Right now we are saving each daily worksheet into its own separate file.
Therefore,
at the end of 1 year, our folder/directory will contain 365 individual Excel
files.
I was just thinking, couldn't we just have ONE master Excel file in our
directory
that is somehow smartly and efficiently compacted into ONE workbook with
365 sheets????

Could I somehow program a drop down list box that allows the user to
select a date??? Once a date is selected, couldn't Excel load the
spreedsheet
for that day???

Thank you!