Forum Discussion
Formula Function on different sheets
There are multiple sheets for one month. We do a copy and paste each week for the data to transfer to the next sheet. However, I need the formula to change each week to reflect the updated numbers bu...
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!
Thank you for your input. I think I will suggest arranging the data on one sheet with a date section. Thank you!