excel
in [Functions]
|
Prev: circular formula gives different values
Next: count the number of rows with entries greater than zero
From: dobbers on 17 May 2010 08:56 I have a spreadsheet linked to others which retrieves data from each month and places the infor in a sumarry table. Rather than change the formulas each month is there a formula that will move the reference to the next row the next month thanks,
From: Luke M on 17 May 2010 08:59
Assuming January reference is in row 2, maybe something like: =OFFSET([Book2.xls]Sheet1!$A$2,MONTH(TODAY()),) -- Best Regards, Luke M "dobbers" <dobbers(a)discussions.microsoft.com> wrote in message news:AB03C335-228A-45F0-A0C7-D3A55556CC1B(a)microsoft.com... >I have a spreadsheet linked to others which retrieves data from each month > and places the infor in a sumarry table. Rather than change the formulas > each > month is there a formula that will move the reference to the next row the > next month > > thanks, |