Macro to sequentially copy cells

[chuff]

Hello, I have a macro that when run will copy the contents of a set column range to another column, and each time I run the macro, the copied contents will be put to the next column over, so the previous contents are not over-ridden. This is close to, but not exactly what I want. I'd like the macro to transfer just one cell from each column, the "sum" cell, and with each new running I'd like it to add the new values below, with a date stamp in the adjacent cell. I've attached a copy of my current fileDUMMY_NUTRIENT_CALCULATOR_DATE-STAMP2.xlsm

Below is the code- I'm a super-dooper noob, so as much hand holding as you can muster would be greatly appreciated. Thanks!

Please Login or Register  to view this content.

[GC Excel]

Hi,
Create a named range in cells B48:F48 named "rngSum" and use this code :

Please Login or Register  to view this content.

See sample file :

[chuff]

This is perfect, thanks for your help!