VBA Find column by header and apply TRIM in that column

[Addictions]

Hello,

Please can somebody help with VBA code?.
I'm looking for VBA code to find column by header name and apply TRIM in that column. Column name is "Title".

I'm also looking for vba code for VLOOKUP. Find column by header name "SKU" and apply vlookup in that column "=VLOOKUP("Should be SKU column here",Sheet2!B:E,2,FALSE)"

Please help.

 

[Addictions]

As a last stage of the process I need to accomplish. What would be a code to copy all data from columns SKU, Title, Picture then paste it in new workbook and save it on desktop as a name results?.

 

[Fluff]

Can you please start a new thread for this.

 

[Addictions]

Sure. Thank you