I have data that is linked and is updated automatically. I am trying to use named ranges for the rolling data for each area and my date range is 5 cells using the Today()-5,4,3,2,1. The dates are rolling fine, but I cannot get the data to update, it stays the same from day to day.
Could someone please look at this and see what my error is? Thanks!!!cookies and kudos
(no password on the unprotect)
Try changing your named range formula to count rather than counta
CCaryAbs: =OFFSET('Abs Import'!$P$4,COUNT('Abs Import'!$P$4:$P$27)-5,0,5,1)
This is for the first chart on the page.
You are a god amongst men sir!! I applied that concept the rest of my named ranges and BOOM!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks