hi all
i need your help please, check both attached files; before and after.
i need to sort column A from A to Z
then
define new names, if same value in column A, then referes the name to all cells contains same values from column A to F.
i can do it manually each time, but what if new rows added? i need some macro to do the sort then to check and do all define names in same sheet in my criteria.
thanks.
Bookmarks