Help with alphanumeric order

[ninjak]

say i have maco that i made to add names to a sheet in row 3 going across. and when i type a name of the person in first and last name it goes to that sheet and adds the names i type in in row 3 all the way across
so when it is done i can look at that sheet and it has all the names there. in the order i enterd them in. what i need is them to be in alphanumeric order on that sheet. Is there a way to make it look at row 3 and take the names and do that some times i add names has the weeks go on. Man not sure if this makes since

Al

 

[Brian from Maui]

say i have maco that i made to add names to a sheet in row 3 going across. and when i type a name of the person in first and last name it goes to that sheet and adds the names i type in in row 3 all the way across
so when it is done i can look at that sheet and it has all the names there. in the order i enterd them in. what i need is them to be in alphanumeric order on that sheet. Is there a way to make it look at row 3 and take the names and do that some times i add names has the weeks go on. Man not sure if this makes since

Al

In XP, there's an option to sort left to right. Include that in your macro.