Delete Multiple Columns based on Header Name

**kingsdime29x** · 05-08-2019, 03:44 PM

I was wondering if anyone could be of assistance with me removing multiple columns within each worksheet if they do not equal either "Def Interceptions or Tackles". The data where this condition would start under column J. I have also attached my workbook as a point of reference.

Is there a way to remove all columns if they are not under this header? Thanks in advance for your help.

**NickyC** · 05-13-2019, 03:59 AM

Hi
I am guessing you want to keep all columns under the merged cells in row 1 with your specified headings. If so, try this macro

Please Login or Register  to view this content.

**NickyC** · 05-13-2019, 04:07 AM

... and this version does the same think in all worksheets

Please Login or Register  to view this content.

Delete Multiple Columns based on Header Name

LinkBack

Thread Tools

Rate This Thread

Display

Delete Multiple Columns based on Header Name

Re: Delete Multiple Columns based on Header Name

Re: Delete Multiple Columns based on Header Name

Thread Information

Users Browsing this Thread

Similar Threads

Sum multiple columns based on month header

[SOLVED] Macro to delete columns based on header

Delete Columns( From One Sheet) based on the header name from a list.

Macro to delete all columns in a workbook based on header name

Sum multiple columns based on header

Count repeated value(text) in Data range based on row header & multiple columns header

Delete Columns Based on Header

Bookmarks

Bookmarks

Posting Permissions