Forum Discussion
Formula Function on different sheets
I strongly recommend arranging all data in one sheet with a dedicated date column.
Excel has plenty of tools for summarizing your data quickly to give you the records you need and there's no need to copy/paste to transfer data. The ideal arrangement of data is in as few sheets as possible with data running vertically with as few columns as possible.
- Patrick2788
Thank you for your input. I think I will suggest arranging the data on one sheet with a date section. Thank you! What Patrick is recommending is exactly what had in mind back at the start, when I said I was almost certain there was a better way to accomplish what you're trying to do. I've made a start at doing that single sheet, but I need your answers to my questions in the last post.
It's hard at times to re-think the way we do things, but that's exactly what's involved here. You ARE already continuing things almost AS IF it were a continuous table. It's just that you're doing significant parts of it manually, with the copy and paste and whatever you do manually to adjust the number of units. Once it's re-designed it will work more smoothly, but we (I or Patrick, or one of the other experts around here) need to know more about what takes place in that week-to-week transition.
