Code to delete columns based on variable

[ken_e]

Hi All

Can anyone think of a code where it would delete whole columns based on the column name which is in the inputs tab.
I need to be able to 1. Change the column order freely. 2. Change the inputs. 3. The code to find the column based on the inputs.
Attached is a sample report.

Thanks

[alansidman]

This should do it for you, but you will have to spell each of the delete column in Inputs exactly the same as the headers in Normalised data sheet. No abbreviations.

Please Login or Register  to view this content.

[mehmetcik]

try this macro:-

Please Login or Register  to view this content.

[ken_e]

Thanks Alan, this is exactly what i need appreciate your quick response!

[ken_e]

Thanks mehmetcik for your code too

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the rep