Pasting values into cells without pasting over existing values

Originally Posted by rwgrietveld

Are these different Workbooks or worksheets?

Assuming that it is the first ou can simply use:

Put this in WB3, Sheet1, Cell A1

=[WB1.xls]Sheet1!$A1&[WB2.xls]Sheet1!$A1

and drag down

When closing WB1 and WB2 it will automatically change to (e.g.)

='C:\Documents and Settings\MyName\Bureaublad\[WB1.xls]Sheet1'!$A1&'C:\Documents and Settings\MyName\Bureaublad\[WB2.xls]Sheet1'!$A1

Two different workbooks. Excellent I'll give it a try.