Feasibility of 365 day workbook???

[Robert Crandal]

I'm thinking about creating a SINGLE accummulative
worksheet for the year 2010 to save our company transactions.

Each day, we will fill in 260 cells of data, which means that
after 365 days (1 year), our single sheet will contain
94,900 cells filled with data.

Does anybody see any problems with storing this much data
on a single sheet?? Is it a bad or inefficient idea??

In 2009, we stored our daily transactions in their own
separate Excel files, which means that I have 365 individual
files at the end of the year, which seems kinda inefficient.
Wouldn't having a SINGLE data worksheet be a better
(and cooler) idea??

Please let me know what u think.

Sincerely,
Bob

 

[Barb Reinhardt]

Unless this is a different question than the one you posted a few days ago,
you've already gotten answers in the previous thread.

Barb Reinhardt

 

[Peter T]

I think only you can answer that, knowing not only what data you have but
what you want to do with it how and how you want to view it. However, from
what you have described I'd say yes, put it all on the single sheet.

Presumably your daily 260 data items all fall under the same headings for
each day, so assuming you have Excel 2007, you have the choice to put your
headings or labels down (say) column A and dates across the top row, or vice
versa.

If you are working in Excel 2003 or earlier there are only 256 columns (1
for labels, 255 for data) so you might want to break things up into say
months or 4 week periods.

Regards,
Peter T

 

[Peter T]

Ah, I wasn't aware of that, looks like there are more relevant answers there
based on the additional details the OP gave in that thread, than the answer
I just gave.

Regards,
Peter T

 

[Tim Williams]

Use Access and you can store every day *and* every year in the same place...

Pretty easy to hook it up to Excel for querying.

Tim