The 2nd sheet (Form) has a data validation. Cell B1 is dropdown list, it will retrieve the data from first sheet, however when a data is empty or null on first sheet, it will return "0". I want it to be just an empty cell. To see the example, choose these following Door No. ATC0001, ATC0002, ATC0003, it will display "0" on certain values. Then compare it on the first sheet to see which cells are empty.Auto_Populate.xlsx
Bookmarks