Hi All,
I need to use data validation based on a data column, in which new stock items are added, same should reflect in the "data validation list" and importantly it should be lively and dynamically update as and when the stock items are added, kindly suggest how to go about this, (we are using excel-2010)
I need to use data validation based on a data column, in which new stock items are added, same should reflect in the "data validation list" and importantly it should be lively and dynamically update as and when the stock items are added, kindly suggest how to go about this, (we are using excel-2010)