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:
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:
'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!
Bookmarks