Need help writing a Copy and Paste Macro

[psabo315]

Equipment Deficiencies 2015.xlsmOk so I'm relatively new to VBA and I have a question on how to configure a macro for a certain condition.

I would like to have an active x button that once selected would paste data from one sheet of a workbook to another. The condition would be that if a specific cell is blank than the information on the adjoining 3 cells would be copied over to another sheet.

In this workbook I would need a button on tab "Jan" to copy the data from tab "Jan" copied to "Feb", then a button on "Feb" to copy to "Mar" and so on. So on sheet "Jan" cell F5 is blank then the contents of C5:E5 need to be copied to the first available cells under priority 1 on sheet "Feb". Same goes for anything under priority 2, 3, 4, 8.

Any help on this would be greatly appreciated. I tried recording the Macro but I keep getting multiple errors.

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum:

Because you are new to the forum, I have changed your title for you. Please take the time to read the forum rules and comply with them in the future

[psabo315]

Understood, Thanks for the look and for changing it for me.

[alansidman]

Try this code. Because you have not provided a worksheet, this is untested.

Please Login or Register  to view this content.

[psabo315]

Thanks I just edited my post to attach the worksheet