User Profile
Nicole0421
Copper Contributor
Joined Jan 28, 2020
User Widgets
Recent Discussions
Re: Formula Function on different sheets
mathetes Thank you for your input. I had to include less detail for privacy purposes but I appreciate that you thought about this. I think I will suggest what one of the other contributors mentioned in putting that info on one sheet. Thank you!!1.2KViews0likes1CommentRe: Formula Function on different sheets
mathetes Here is a very shortened version of the report. So each sheet is a different week of the month. Units are added to the 'units' column each week. When we do a copy and paste for a new sheet, the 'units remaining' column doesn't change for the new week (since it's a copy/paste.) We need the new week to reflect a different formula since we are adding in new units that will then change the 'units remaining'. I hope this makes some sense. Any and all help is appreciated.1.3KViews0likes4CommentsFormula 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 but I can't figure out how to change the formula for each new week (each new sheet.) Is there even a way to do this? Or do I just need to copy/paste the new updated numbers then go back and copy/paste the other information? Looking for the easiest way. Thanks!1.5KViews0likes10Comments
Recent Blog Articles
No content to show