This may seem to have a simple solution, but when I insert a name and date in worksheet 1 , I want the info to transfer automatically to worksheet 2 in the same formatted columns, but not be modified any more when I change anything in worksheet 1. For example, with dates, right now, I am using the formula =IF(H29>0%,TODAY()) the date will automatically change each day, but I just want it for the date it occurs then stay that way, not change every day to the current date, because that will also affect the date on worksheet 2. Is there a formula that will keep the original date on worksheet 2, rather than change to the current date each time?
Bookmarks