Quote:
Originally Posted by jsyowler
Trying to make multiple lists based on the first character of a master list onto seperate sheets. I.E. I have a master list in sheet 1. I would like to make a list for each letter A-Z on corresponding sheets. I have 4500 items in the master list. Cannot figure out how to use the Vlookup and Left function together as well as returning multiple items between seperate sheets. Thank for all the help in advance!
|
I read your question and tring to find some helpful suggestions for you and in this case I got an article, going to share. Hope you can find your solution.
Code:
http://knol.google.com/k/excel-dummies/excel-s-most-powerful-functions-vlookup/3hxc2p2hmax0x/1#