I’ve created a fairly simple Excel workbook in which there are 10 data entry sheets (containing date, service, and initials) and a master sheet (containing the exact info on all of the other sheets, but compiled into one sheet). The master updates automatically when any data is entered on the other 10.
What has me stumped is when there are blank date cells on the entry sheets, it shows as 1/0/1900 on the master, and I can’t figure out how to get rid of that. I want it to show blank on the master when there are no dates entered on the entry sheets, but I can’t seem to find how to do that. (Dates and other info will be entered in the future.)
Also, other empty cells on the entry sheets show up as 0 on the master. I’d like these to be blank when there is no data on the data entry sheets, also.
So how do I do this?