Google Sheets: yearly budget sheet streamline help

[Mike Luce]

Major part solved but open to improvements.

I have a yearly budget sheet that works great until it's time to start a new year and then I end up clearing data I don't want. i also have a formula or two i can't get to work right.

Is there a way to set up a button to clear data from columns?

My current layout is a Master sheet that is fed by 12 Month sheets that are fed by 5-weekly sheets each.

I've placed as many comments and notes as I could think of to explain would I am trying to accomplish is a copy that's open to editorsHere. I've only marked up through Jan so Feb forward is all old formats and data that would be converted to match new formulas.

[AliGW]

I’ve added Google Sheets to your title for clarity.

[Mike Luce]

because I'm not one to leave anything alone even after i ask for help a co-worker saw me trying to strangle the keyboard to figure this out a provided me with a Macro to clear the weekly sheet that is to large to post here but i will include a chunk of it for review i anyone thinks it can be improved or simplfied..

Please Login or Register  to view this content.