i have a problem copying cells between worksheets in the same workbook. most
of the cells copy and are linked OK but the 2 final columns in the worksheet
table copy and show a zero value. in the formula bar it shows that the cell
is copying the correct data. if you copy the data from a cell that is working
within the same worksheet it just copies the total from the cell and then
when you F2 the cell it shows a xero value. this is difficult to explain but
it seems that most of the worksheet is working OK but the end 2 columns are
acting quite differently.