I have an Excel document that auto-sorts my 'Date Due (NLT)' column which is exactly what I needed. However, I've learned that I cannot protect the worksheet without losing the auto-sort capability and I need to protect every column except my 'Last Completed' column. My thought was to use vlookups and another worksheet that I can simply hide from the end-users, but I'm not sure how to approach this given the dynamics that the auto-sort coding present. Help, please!
Hi,
I understood your issue. please share your excel file so that I can help you in better way. Apart from functions and excel features we have macro and vba also . So if your problem was unsolvable with functions we can implement macro on it.
Please give me opportunity to work on your project.
Thanks
$55 USD em 3 dias
5,0 (5 avaliações)
4,1
4,1
6 freelancers estão ofertando em média $98 USD for esse trabalho
Hello,
I went thru the description
It's pretty challenging. Can you discuss more on that?
Maybe I can find you a solution
You can see my previous projects and reviews
I look forward to hearing from you
Thanks
Regards
Thushara
I'm an experienced software engineer in the Pacific Northwest. I can help you with your auto-sorting feature in your spreadsheet. I can add a macro to the workbook which will turn off sheet protection, do the sorting, and then turn it back on when a value on the sheet changes.
Please message me so we can discuss exactly how your spreadsheet works and what you need so that I can help.
Thanks,
Gabriel