I have an excel worksheet that contains data that will update on a daily
basis. So I insert copied data at the top of the sheet some everything is in
date order. Then at the end of the data I do many calculations with count,
if, and sum statements. Everything calculates correctly except when I
insert new data the starting point of the formula doesn't update but the
ending formula does. I have auto calculate on and even when I manually try
to update the beginning point still won't update. If I go edit everyone of
my calculations it works fine.
Does anyone have suggestions on how I get around manually updating the
formulas everyday?
Thanks.
Bookmarks