There are two tables one is Master table and other is Specification
table.
The Specification table contains the multiple columns colour, size,
product1, product1-material, product2, product2-material, product3,
product3-material from A:H in sheet1. The data type is, colour and
products are constant for whole size range and the products material
will change for particular size ranges. There will be different colours
product too.

The Master table contains the columns colour, size, product, product
material. A:D in sheet2.Now the question is how to append the data from
the Specification table to Master table i.e append data from columns
colour to colour, size to size, product1 to product, product1-material
to product material and similarly for other products data also from
Specification table to Master table.

I would be grateful if anybody can suggest how to go on this.

Regards,

Shiva


--
Shiva
------------------------------------------------------------------------
Shiva's Profile: http://www.excelforum.com/member.php...o&userid=28449
View this thread: http://www.excelforum.com/showthread...hreadid=482576