Macro to delete all columns except specified headers

**macattackr** · 01-26-2012, 10:55 PM

Hey there everyone,

First post on the forum, have been grabbing info here for awhile. Feel free to blow me up when I don't follow the SOP.

I am trying to create a macro that will delete all columns aside from those specified. They must be labeled by the actual column header as data imports can vary greatly. Columns I would like to keep, based on header name are: Word , Pay, Cost, Volume, Rank, & Type

I really have searched the forum high and low also all over google. Everything is detailed on deleting rows or deleting columns by specifying header to be deleted (not what I want to achieve).

Thank you.

**MarvinP** · 01-26-2012, 11:12 PM

Hi macattackr and welcome to the forum.
Try this code in the attached sample file.

Please Login or Register  to view this content.

Note - LastCol looks in Row 1 for your column headers.

**macattackr** · 01-27-2012, 01:54 AM

Hey Marvin that worked great....thank you...i will be submitting another question shortly! starting to learn and pick it up

**jkho** · 03-28-2013, 10:02 AM

Wow thanks, I am an accountant and my manager just asked me to do the same exact thing. This worked perfect!

**milkfloat** · 05-07-2013, 10:44 AM

hi all its my first post, so please bare with me

i used the marco you posted and it did the job! Thank you

what i also need to do is make the data which remains into a table without manually doing it. is there anything i could add to the marco that would convert it into a table once it deletes the irrelevant columns?

**arlu1201** · 05-07-2013, 12:44 PM

milkfloat,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.