View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Thomas Peter Thomas is offline
external usenet poster
 
Posts: 1
Default Absolute reference problem - Excel 2007

Hi,
I have to obtain the sum of a column and then have to have that total
appear in another sheet of the workbook every month in order that I
can keep a track of each month's expenses - so far that is no problem.
However, the length of the column varies each month so I am prevented
from using the absolute reference function - can anyone please suggest
how I may overcome this? I am using Excel 2007
--
Cheers

Peter