Not quite the answer though it was getting close.

The column information I receive daily is 4 columns of which is the
added to the remaning columns in another spreadsheet.

The data that changes daily is: "stock status", "price", "produc
name", "product code".

The other spreadsheet contains things like urls and image links an
names etc.

So it is vital that when updating these bits of information do not ge
adjusted or removed.

This is dropshipping at its worst!!! My suppliers only update me on th
4 columns as stated above. It is then upto me to create a database t
reflect all of this on a daily basis

--
kc
-----------------------------------------------------------------------
kcm's Profile: http://www.excelforum.com/member.php...fo&userid=2370
View this thread: http://www.excelforum.com/showthread.php?threadid=37381