As Per Heading copy data from Input to Output Workbook

[rr1050]

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

[rr1050]

Anyone respond pls?

[JOHN H. DAVIS]

I couldn't get this to work with the merged cells in Rows 1 and 2 on your Output WB. However, it did once I unmerged the cells. Hope that helps.

Please Login or Register  to view this content.

[rr1050]

This work Great!
Many Many Thanks

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.