Updating last data entered in excel

18-Sep-2016 16:36

As we know Data Validation feature improves the efficiency of data entry in excel and reduces mistakes and typing errors.

updating last data entered in excel-6

Free online nauughty cams

Now we create the dynamic drop down list in cell D9, follow the steps given below:- Note: – When we click on OK, in Excel, window pops up saying that there is something wrong with the input.To check that, when we go to cell D10 and check the drop down list, we can see the same old drop down list with no new product.