Select and import subgroup

[Szymon]

Welcome

I have some question - someone know how can i use Access to match datas and import subtable?
It's my data:
table 1 http://imageshack.com/a/img607/8155/a3yw.jpg


table 2 http://imageshack.com/a/img89/7038/vxps.png

I would like to import to table 1 group of data from table 2 - match 2nd Item number from table 1 and 2nd Item number from column V-table 2 and when it's the same import to table 1 column U and V... It's should import subtable with data or somethink like that.

Please help

Thx

[June7]

I would like to say just create links to the two sheets and then manipulate them like tables. But the second sheet is not structured to allow clean linking (multi-line header, subtotal rows).

Otherwise, need a LOT of code that opens the worksheets as objects in VBA and manipulate to read each row/cell and process data as appropriate. To do what you want would be very complex.