macro/action needed on save

how how if I hit save In excel can each sheet in a workbook sort all the rows from top to bottom if a specifc column value in "COMPLETE"

so essentially if I set i.e. column A row 4 to "complete" whilst rows 1,2,3 are blank, it should sort row 4 to the top of the sheet

all help will do
rutgermonsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne Taylor (webtubbs)Commented:
What do you mean by this?

"...it should sort row 4 to the top of the sheet"

Do you mean you want the row with COMPLETE in column A moved to the top?

Can you post a sample workbook showing before and after?
0
NorieAnalyst Assistant Commented:
What if there's more then one row with COMPLETE in column A?

What other values can be in column A?
0
Ramesh VCommented:
Can you share the workbook please?
0
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

rutgermonsAuthor Commented:
see attached, sheet 1 is current , sheet 2 is desired state
sort-on-complete.xlsx
0
Ramesh VCommented:
Hi,
Test the attached.
How to:
Enter something in A and B. Just press CTRL+S (Save), observe that data will be sorted automatically just before SAVE.
But one thing is the workbook should be as .xlsm or .xls. If you want this in .xlsx its not possible.
0
Ramesh VCommented:
0
rutgermonsAuthor Commented:
seems to work but if I type COMP or COMMS for example, this also sorts and move to the top, how can it specifically only sort on the hardcoded value (COMPLETE)?
0
Anne TroyEast Coast ManagerCommented:
Try this one.
sort-on-complete.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.