The discussion revolves around methods to delete specific columns in Excel based on certain criteria related to the values in designated rows. The focus includes both macro-based solutions and manual methods, with varying conditions for column deletion.
Participants express differing opinions on the best method to achieve the desired column deletion, with some favoring the macro approach for its efficiency and others preferring a manual method for its simplicity. No consensus is reached on a single preferred solution.
Participants discuss specific criteria for column deletion that may depend on the structure of their data, indicating that solutions may vary based on individual use cases and data arrangements.
Private Sub CommandButton1_Click()
For iColumn = 9 To 3 Step -1
If ActiveSheet.Cells(10, iColumn).Value = 0 Then
ActiveSheet.Columns(iColumn).Delete Shift:=xlToLeft
End If
Next
End SubHi BvU, may be I was not clear in describing what I wish to do. I attach a data that I want to operate on. In this data I wish to conditionally delete any columns that does not contain the value (1) in either row 1 or 2 and any column that contains (1) in row 1 and 2 but contain other (1) in row 4. After the deletion, only columns A and B remain.BvU said:
I found a simple solution. I highlight row 4 then use the function (find), this will find the value (1) in row 4 and then I delete all columns containing (1) leaving only columns A and B as desired.Adel Makram said:
Yes, but that's a relatively tedious manual method, will need to be repeated if the data changes, and is subject to human error if repeated. Adel's suggestion of a macro is much more versatile and easily repeatably. If you need this sort of thing very often, you would do well to learn a small amount of VBA.Adel Makram said:
Adel is the OP. The suggestion was from BvU.phinds said:
OOPS. Thanks for catching that Mark & my apologies to BvUMark44 said:
