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!
This is a cross post: Link to other post (https://www.excelforum.com/excel-programming-vba-macros/1238369-deleting-data-in-a-rows.html)
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!
This is a cross post: Link to other post (https://www.excelforum.com/excel-programming-vba-macros/1238369-deleting-data-in-a-rows.html)
