The title should read "2nd tab" not "end tab....I don't know how to correct the title. SORRY.
_________________________
Hello,
I'm trying to write a formula that automatically copies data from one tab to a specific range on the next tab, and appear in alphabetical order even though it wasn't that way on the first tab.
The data that I want copied is in the second column, but which gets copied depends on the info in the first column A. So in the first tab, it looks like this...
COL A COL B
1 nillusory
2 proliferate
3 zany
1 inexplicable
1 cinnamic
1 nonprofessorial
1 timber
4 engender
1 busiest
and in the second tab (say Group 1 tab), I need it to look like this (grp 1 only arranged alphabetically):
COL A
busiest
cinnamic
inexplicable
nillusory
nonprofessorial
timber
The first tab is going to be modified by other people, so I need for the second tab to adjust correctly as they put in new words, or delete them.
THANK YOU SO MUCH!
I've attached a little example file...
Bookmarks