Forum Discussion
HELP! I'm stuck
I am trying to make a workbook for the motel I work for to speed up our Daily Operations Report. When I add a new sheet at the bottom for a new day and copy over my formulas I can not figure out how ...
My advice is to keep your daily data in one sheet and add a column for the date. Looking ahead, you could potentially have 365 sheets in the workbook to manage. Maintaining those sheets and analyzing the information is possible but it would be a chore. Excel has plenty of room in just one sheet with 1,048,576 rows.
- CLoveday1982, you are welcome and as Patrick2788 restated (and probably said better) option A is the preferred method. That said we are often under time crunches and option B might get you a temporary quick fix but please make time to consider and then restructure your data so you enter it in a single table (at least all data of 1 'type') and do NOT split the data across sheet just because they are different months. Basically treat data entry as entering all relevant data and then data reporting as using excel to pull the relevant data in the way you want and making it look pretty. Then you can produce many different reports much easier.
