Deleting data in a rows

[nekmat97]

Hello all,

I have a spreadsheet that has data from B3:AA15000 that is filled with numbers. I also have a drop down box in cell A1 where a logical (i.e. >,<,<>) is chosen, a drop down box where a data type is chosen (A,B,C,D, these data types are column headers for columns X:AA) in cell B1 and the value is entered in cell C1, and if the criteria is met (e.g. value = 100, logical = <, data type = A), all the values lower than 100 in cells column X3 which is data type "A" are deleted, but also the row that contains this data is also deleted.

So for example, if Z100 has a value lower than 100, the whole row "100" is deleted but only from X3:AA15000.

Any help would be greatly appreciated. Thanks!

Edit this has been cross posted to https://www.mrexcel.com/forum/excel-...ml#post5106771

[BadlySpelledBuoy]

(e.g. value = 100, logical = <, data type = A), all the values lower than 100 in cells column X3 which is data type "A" are deleted, but also the row that contains this data is also deleted.

So for example, if Z100 has a value lower than 100, the whole row "100" is deleted but only from X3:AA15000.

Just for clarification, is this a typo? I thought Data Type A pertained to column X, so unsure why we'd be deleting row 100 if Z100 was less than 100 as per your example.

Might be a good idea to attach a small sample workbook so we can fully understand your data layout.

BSB