VBA code will not iterate cell values.

Hello all,

I am working on a excel file that that I would like the sums two dates sum and converted into seconds and then transfer the calculations to a .csv file. I received help on this forum a little while ago, however I am now having a bit of an issue with VBA code for my file.

In the attached file the line of code that was given to me:

Please Login or Register  to view this content.

That should return the amount of seconds between the sum of time times Brain!B$2 (Today()) and 'Request Guest'!D3(Date entered by me on the request guest worksheet) *86400.

Everything works fine expect in the line of code from the attached worked sheet:

Please Login or Register  to view this content.

'Request Guest'!D2 in the formula MAX(0,'Request Guest'!D2-Brain!B$2)*86400) dose not update to the next cell value !D3, !D4, ect..
I have tried to rewrite the formula but either the new formula produces an error or dose not return the correct results.

I am not sure how to get this value to update correctly?

Any help is much appreciated!

Originally Posted by TMS

Please Login or Register  to view this content.

Regards, TMS

Awesome Thank!