VBA code to select the columns based on a specific header name

**misterno** · 12-03-2022, 03:40 PM

I receive this excel file on a daily basis which has over 50 columns. The problem is the order of columns keep changing but the headers are not.

So I need a vba code to pick these columns based on the header (title) and cut/paste to column A then B then C then D then E. So there are 5 different columns that needs to be cut and paste among 50 columns and place them at the very beginning of columns A thru E.

Can somone help?

Thanks

**mjr veverka** · 12-03-2022, 06:32 PM

For example:

Please Login or Register  to view this content.

**misterno** · 12-03-2022, 07:08 PM

it works

Thanks

**alansidman** · 12-03-2022, 07:58 PM

Are the column names always the same? If yes, then you can do this by filtering in Power Query to delete all columns in the query except those and load the results to a new page.

VBA code to select the columns based on a specific header name

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to select the columns based on a specific header name

Re: VBA code to select the columns based on a specific header name

Re: VBA code to select the columns based on a specific header name

Re: VBA code to select the columns based on a specific header name

Thread Information

Users Browsing this Thread

Similar Threads

VBA Code to do a Header change , Copy only specific header and paste

[SOLVED] Code to select first row below header after filter

Select column based on header VBA

[SOLVED] VBA for printing specific header, specific columns and cells to one page.

[SOLVED] Copy columns based on header (Without header)

[SOLVED] Select specific columns based on column numbers

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

Bookmarks

Bookmarks

Posting Permissions