Dear Friends,

I have two workbooks, name Input and Output. Input workbook having worksheet “Heading Input”, which first row having several headings and data below headings. I want in output workbook in tab “Collected Data” copy data as per heading. Copy condition, without heading first row to last row for that column. Heading may not identical as word to word/or space so pls use trim function in VBA while looping.

Expected VBA code, which consist wide range of heading from Input sheet. (column A to BM). It is sure heading names in input file unique and written in first row of file. Same for Output file, fix place but sequence may change of data requires.
Just for easy way, I have attached dummy sheets, pls respond for my help!

RL


Input WB.xlsxOutput WB.xlsx