|If I understand you correctly, you have something like this:|
A B C D E
1 5/2/2013 5/9/2013 5/16/2013 5/23/2013 5/30/2013
2 95 97 102 93 110
You then want to replace the 5/2/2013 with 6/6/2013 and end up with this:
A B C D E
1 5/9/2013 5/16/2013 5/23/2013 5/30/2013 6/6/2013
2 97 102 93 110 98
If that is correct, there is no formula that will force an automatic sort. You would need a macro.
I don't want to spend time writing a macro if my initial assumption is incorrect, so please verify that I understand what you want to do and that a macro based solution is acceptable.
If there are any more details that you think I need to know, please provide them so that I can get as close to a working solution as possible. Please keep in mind that I can't see your spreadsheet from where I'm sitting, so the more details you provide, the better.
Note: If all you want to do is show a certain number of weeks, e.g. the last 5, then a formula based solution is possible as long as the last 5 weeks can be displayed somewhere other than where your existing data is now. It is the fact that you are overwriting existing data that makes an "automatic sort" require a macro. If you were willing to add the latest data to the end of the existing data, then formulas could be used to display the last X weeks in a different location, e.g. on another sheet. You could then use that sheet for whatever you doing with your updated data now.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.