Hi All,
A while ago I saw someone had a workbook where they have two sheets; one contained names, addresses, phone numbers ..etc... The other had a roster. On the first sheet each row (person) had a number assigned to them.
What they would do is if they wanted to put Jack Jones on the roster, they check sheet one and see his assigned number, type that number in the roster sheet row, and bada-bing, all the data from sheet one goes into the right cells on the roster.
I need a clue how to get this started.
Thanks.
Bookmarks