Macro to update balance sheet. Trying to loop until row is blank & copy/paste.

Hello,

Firstly, thank you for any help/suggestions, it's greatly appreciated!

I created this balance sheet for my boss as a "fun" way for employees to track their stats each month. I'm embarrassed by the code because I know it's all over the place but it works.

Basically they input their stats and then manually type in their results at the end of the month and the macro clears out the page to reset for the next month (macro ran by clicking on image top right).

What I'm trying to do is automate that process to copy/paste value from F22 and K22 to the next empty line in the ranges F25:F35 and K25:K35 and to select the yes/no drop down I25:I35 if there was a hoc as well.

As you can see with my lengthy if statements I usually steer clear of loops but I think this is the best route. Any suggestions on what type of loop to use?

Thanks!




Example.xlsm

Since you like using and know how to use if statements and your code is all crazy... why dont you just add 12 other if statements stating... if Date which would be todays date is between 1st of Month and 30th of Month then copy data to whatever month it is... I would help at just writing it for you but your code is way confusing already and I would have to redo everything...