I have three worksheets: Defects, Worklog and Merged.

Merged is blank (but populated below to show expected results)

There is a key column in each which joins the data (Defects.DefectID = Worklog.ItemID).

I want to be able to quickly merge the data between Defects and Worklogs into Merged.

Data looks like this (but has many more columns and rows in reality).

Please Login or Register  to view this content.
The data in defects and worklogs worksheets is variable.
That is, the number of columns and rows can and will vary per worksheet.

The columns representing the key column can also vary (ie will not always be column 2 for defects and column 1 for worklogs).
It can be identified by its name ‘Defect ID’ and ‘Item ID’

There may be defects in defect worksheet that are not in worklogs worksheet.
They should be included in the merge results with blank worklog data.

There may be worklogs in the worklogs worksheet that are not in defects worksheet.
They should be included in the merge results with blank defect data.

The sort order of the results is not important.

Thanks