rutgermons
asked on
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
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
What if there's more then one row with COMPLETE in column A?
What other values can be in column A?
What other values can be in column A?
Can you share the workbook please?
ASKER
see attached, sheet 1 is current , sheet 2 is desired state
sort-on-complete.xlsx
sort-on-complete.xlsx
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.
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.
ASKER
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)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"...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?