D
Dave Coz
Hi all,
Looking for a formula to help on my problem: I have a worksheet with the
totals in row 2. The data beneath that will be added to everyday with the
most current day being place in row 3. I then need to the total in row 2 to
just take the first 100 rows of data (B3:B102). If i use "absolute refs" and
then insert a row, it will update the forumla as well.
I can write a macro to do this, but was more curious about a formula based
approach.
Any help you can offer would be greatly appreciated.
Cheers
Dave
Looking for a formula to help on my problem: I have a worksheet with the
totals in row 2. The data beneath that will be added to everyday with the
most current day being place in row 3. I then need to the total in row 2 to
just take the first 100 rows of data (B3:B102). If i use "absolute refs" and
then insert a row, it will update the forumla as well.
I can write a macro to do this, but was more curious about a formula based
approach.
Any help you can offer would be greatly appreciated.
Cheers
Dave