Hi,
I read through my explanation and realized that one small thing was not to 100% clear: After typing =today() in the cell you should hit enter! After this continue with copy... etc.

After you have recorded this macro again, using the clarification above, try it again. If it still doesn't work, publish your recorded macro here and I will hopefully find the error.

You can find the macro details via the menu Tools / Macro / Macro... (or Alt-F8). After this select your macro and click on "Edit". Now you will see the macro and can copy-paste into a reply here.

Kind regards
Bjorn