Thanks. I formatted the cells for Date. The problem is that if it is supposed to be blank, it shows the date 1/0/00. I need it to be blank if the field is blank on the first worksheet.
Thanks. I formatted the cells for Date. The problem is that if it is supposed to be blank, it shows the date 1/0/00. I need it to be blank if the field is blank on the first worksheet.
I did not see your attached file. I opened it and found your example and it solved the problem.
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks