Hello everyone,

Every morning I run a macro which inserts a new worksheet into a workbook. The macro works great however now I would like to add code to insert the following formula into cell G1 of last worksheet:

=[value of cell G1 in the 2nd to last worksheet of the workbook]+sum(F3:F65000 of the last worksheet in the workbook)

Below is what I have so far but it's not working.... 


Please Login or Register  to view this content.
I've tried a few different combination and still no luck. Suggestions?

Thanks!

Nick