Hi,

Am bussy compiling a summary of certificates and can't get excel to number
up automatically when I copy (pull down with mouse) the cell. I need the same
cells from different certificates. It keeps certificate one and I have to
change it all by hand for a dozen colums.

=C:\my documents,... '[certificate 1.xls],VAT'$D$24
=C:\my documents,... '[certificate 2.xls],VAT'$D$24
=C:\my documents,... '[certificate 3.xls],VAT'$D$24

etc

Thanks