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...
Nicole, I'm sure there IS a way to do what you're asking.
I'm also almost certain that there's a better way to do what you're doing. Any time we get to a manual procedure that involves regular copying and pasting, it's pretty much certain that it's a given: we could do this more efficiently, taking advantage of Excel's abilities with Tables, and data in general.
Is it possible for you to upload a sample of the actual spreadsheets (making sure that any confidential or personal info has been disguised)?
Thanks for the reply. I'll have to check with my boss if I can upload. If I can, I will tag you. Thanks.