Find multiple column header, filter out other columns, and export data using a macro

Hello - I have multiple workbooks with 30+ columns in each workbook which are arranged in different orders. In each workbook are the same 5 columns scattered amongst the data. I want to create a vba, so I can open a file and:

1.) Find the same 5 column headers in each workbook
2.) Hide the remaining columns
3.) Copy and paste the data as a value into a new workbook that is not connected to another data source (have had problems with data linking to other tables during copy and pasting)

Thank you!

It does not do what you ask for, it does not hide columns, but who knows, you might be happy after all
Make sure to change all references where required. The workbook with the code needs to be saved in the same folder as the other workbooks.
Have a "dummy" folder to try it on and come back to let us know what needs tweaking/changing.

Please Login or Register  to view this content.