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?
 
Anne TroyEast Coast ManagerCommented:
Try this one.
sort-on-complete.xlsm
0
 
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
 
NorieVBA ExpertCommented:
What if there's more then one row with COMPLETE in column A?

What other values can be in column A?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Ramesh VCommented:
Can you share the workbook please?
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.