Hi all,
I have a spreadsheet that has a large number of columns, and currently caters for a maximum of 9999 rows of "user" data. Now because of performance issues, I am thinking that I can chnage the sheet to only cater for a few rows of data initially, and then expand to cater for however many rows the user enters into the sheet.
However, one of the problems I have is that many of the cells have data validation enabled, or a drop down list of permissible values, or are conditionally formatted. So at the moment, all of these things are applied to 99999 rows.
If I reduce the number of rows to just a few initially, I am wondering what might be the best/most performant way of adding these validations to the rows the user adds?
Although a user can enter a new row manually, they are also just as likely to copy and paste 3000 rows from another spreadsheet and then paste them in. So if they do that, should I write some code that looks at the used range of the data and adds the appropriate validation to each cell?
Doing it this way does not sound very efficient to me, but as it stands, the current way of having all these validations already there on 9999 rows is also making using the sheet a nightmare.
Any ideas?
Bookmarks