I have data validations like drop down, type only numeric values,date format etc on my excel. i need to filer names and copy filtered data to another excel.
When i use read range and output as data table,
it doesnt copy data validations such as drop down,formulas etc.
how can i do it. its little urgent. please help.