Based on Podcast # 1808

[kevint2021]

Hi and Thanks for answering my question. I have developed an Invoice Program based on Episode 1505 and 1808 and it is awesome. Just have one issue outstanding. On the invoice I have set the date using a workaround to maintain the date stamp from changing when the worksheet recalculates and it works great on the register. However, when the invoice is copied to the Invoice Archive folder the dates change on the invoice copies on the .xlsx file. FYI the workaround that I used to maintain the date stamp was to Enable iterative calculation and set to Maximum iterations to 1. Is there a way to ensure that the Invoice Archive copy to maintain the original date? Thanks so much for all of your Youtube videos it makes Excel fun to use and so useful to us novices out here.