Hi.
In column B I have a list of records.
In column E I have a data validation list drop down.
The intent is to have a user select a value from the drop down in column E, for each record in column B.
What I need is a vba that automatically drags this data validation drop down to a certain point.
This 'certain point' refers to a text in column B. For example, if column B line 34 has a text called 'TOTAL', then I need column E to only drag down to line 33 (before the 'TOTAL' text).
The number of records in column E changes, therefore it would be nice to have an extra piece of code that cleans up the data validation; i.e. no data validation list drop down for anything below or at the level of the 'TOTAL' text.
Thanks in advance.
Bookmarks