I would like to automaticly sort my data by the following:
Sort by column B
Sort based on values
In order of A-Z
(only on sheets "master" and "updates")
can i do this in VBA to make it automatic in my excel file?
I copy/paste data throughout the day into sheets in this workbook and would like it to always be sorted for me.
Also - the sheets master and updates are deleted throughout the day and re-created - so hopefully vba wont #ref all the ref's to the sheets as they will be back later?
Sort by column B
Sort based on values
In order of A-Z
(only on sheets "master" and "updates")
can i do this in VBA to make it automatic in my excel file?
I copy/paste data throughout the day into sheets in this workbook and would like it to always be sorted for me.
Also - the sheets master and updates are deleted throughout the day and re-created - so hopefully vba wont #ref all the ref's to the sheets as they will be back later?