I am creating a profit and loss acounts in excel with several worksheets : ie
one for wages, one for motoring expenses and one for telephony expenses etc.
On some of the worksheets I have totals from 3 different items such as land
line telephone and mobile telephone ect each with a separate total. Is there
a way to create a link so that all three colums can be added together and the
total sum added and placed in the cell on the P & L worksheet.