Merge worksheets with different structure

[Dontik]

Hi


I have a workbook with over 100 worksheets. They have a different structure (some columns are in all of those worksheets, but some are not). If there an easy way to merge them by columns they have in common?


Thank you in advance!

 

[tonyyy]

Dontik,

They have a different structure (some columns are in all of those worksheets, but some are not).

Should we assume you mean column headers when you refer to columns?

If there an easy way to merge them by columns they have in common?

How do you want the common columns merged? A new sheet with all the common columns in separate columns? All columns in a single sheet with common columns stacked upon each other? Something else?

Cheers,

tonyyy