delete unnecessary columns

Hi ,

can someone help me write code how to delete unnecessary columns and keep the columns mentioned in "Output columns"sheet.

For example in the sheet "Raw" my columns changes everyday but only few columns remain same rest would be new.(new columns would be unpredictable).

Hence i want to remove those newly added columns but based on the validation sheet "Output columns" there for keep all the columns in raw sheet from the list available in "Output columns" sheet. rest delete

enclosed file for you use

Thanks & regards,
hudson

Hi !

According to your attachment that just needs to delete any column after column P without the need of the second worksheet …

How about

Please Login or Register  to view this content.

Fluff13,

This is crazy and it look fantastic it worked like charm!!!

Thank you so much

Hudson

You're welcome & thanks for the feedback