View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Barnard Mark Barnard is offline
external usenet poster
 
Posts: 12
Default How do I advance cell numbers?

Hi!

In one worksheet, I have two columns: 1 column of dates and one column of
numbers. On this worksheet, I sum the column of numbers based on the
previous 90 days.

Is there a way that I can enter a new date and number in one place on a
different worksheet, and have it load that date and number in the next blank
spaces on the worksheet I describe in the above paragraph? I would then want
the next date and number I load to advance to the next blank spaces on the
first worksheet, etc., etc. It is important to keep the 90-day total current.

Thanks in advance...

Sincerely,

Mark Barnard