On the attached spreadsheet I would like to use a macro to delete rows if the following data exists in a number of columns as follows.
col b equals 1
col h 6 or less
col j 6 or less
col j 49 & over
col n equals 15
col s equals 2
col y 14500 & over
col aa 10000 & over
col ag 0.4 & less
col al -24 & less
col bb 18 & over
col bc negative values
col bc 14 & over
col bd 13 & over
col bd contains text "low"
col bi equals 1
A shortened version of a larger spreadsheet is attached highlighted in red are the rows to be deleted,highlighted in brown are the rows to be kept.Many thanks for help given.
Bookmarks