I am completely green to VBA and need to get an excel spreadsheet to create a new workbook when I press a button. I do not know anything on how to do this so any help will be greatly appreciated.

I want to push a button and have the macro run.

I want to have the following happen:

If there is a future date in any of the following cells R, V, AA, AF, AH, AK, AP, or AU I want it to copy the following
for all I need C, K, L, M, M, O, P, Q, R to copy over and then if R if it is a future date, V and X if V is a future date, AA and AC, if AA is future, and so on except AU only if AU is future date.

I would then like it to ask me if I want to email the new workbook. If yes to email to a distribution list and if no to end.

the original spreadsheet is called "CPC" and I want the new workbook to be called "CPC Schedule"

Can anyone help me????