Hi All,

I am new to excel and currently am suppose to further improve an existing program for my project.

Currently the existing program append results monthly to an worksheet in the workbook however there is a constraint to it as excel only limits it to 65,000 plus rows.  I would now like to open new worksheets for each year and put these results and categorise them on a yearly basis.

Would appreciate if anyone can give me some advises on the above and perhaps give me some directions.

Thank you.

Cheers

Hi,
If you have got that much data to store then my advice would be that you need to give some serious thought to moving things into a proper database, such as Access. Here you will be able to store and manipulate the data much more easily.
If you really must stay in Excel then why not create a worksheet for each Month, then you could create an additional Sheet as a "Summary" and pull the Monthly Totals from each relevant worksheet. That would overcome the Row limit on each sheet.



____________________________
multi-tasking - the ability to hang more than one app. at the same time.