Excuse my ignorance I will try and explain this as best as possible. I utilize a spreadsheet pulled from the company server. Each week I refresh the spreadsheet to grab the most current data. What I am trying to find out is if there is a way/formula to automatically sort and rank a certain sheet each week after the refresh. Currently I have to manually rank each sheet weekly. I?m hoping there is a formula that can be set up to do it for me.
Hi there.
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet (not necessarily your real sheet... but something that accurately represents your real sheet) complete with an explanation and some expected results.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks