I am new to macro and need your help to develop a macro.
So I want to copy all the columns with specific column title into a new excel sheet.
Suppose if the there are multiple columns with title as Load, Force, Newton, Part etc. and there are many columns with the same title, for example 3 of Load, 10 of Part etc.
How to copy them into a new excel file.
Program would execute from the sheet "Summary" and should ask Tile name of column which needs to be copied into new excel file.
Bookmarks