Hello,
I have a spreadsheet that multiple associates use to track the types of calls they recieve. Each day they email me these reports and I combine them into a single, weekly report. To get an idea of what the volumes are each day, I wanted to create a formula that would stamp the date in column H when a value is entered into column B. I want this date stamp to be static so that I can combine the spreadsheets later without worrying that these date stamps will change.
I have seen the VB solution and while it does work, it triggers the Macro warning when the sheet is opened and we don't want to change the level of macro security. I tried using this formula:
=IF(B2="","",IF(H2="",NOW(),H2))
It works if I go to Tools, Options, Calculations Tab, and click the check box for Iteration. But when I completely close Excel and open it again, the Iteration box is no longer checked and the formula doesn't work.
Here are my questions:
Is there a way to have the sheet provide a static date stamp without using VB solution or macro? Can we get Excel to retain the Iteration flag so that it doesn't reset each day when you open Excel up again? Is there another solution that works seamlessly to provide this static date stamp without any input from the users and still allows other formulas to run?
Any help is appreciated.
Thanks,
-Tom
Bookmarks