HELP WITH EXCEL

Closed
mindy - Jul 1, 2010 at 12:20 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 1, 2010 at 02:36 PM
Hello,

I am a super novice on excel. I am creating a database with names phone numbers and addresses. It is a total of 16 worksheets. One of the worksheets is an invoice. I am trying to get it to auto fill names addresses and phone numbers once i start typing the name of a client. is this possible/teachable for me? the tutorials I keep finding sound like chinese to me and I am lost and overwhelmed!



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 1, 2010 at 02:36 PM
By auto filling another sheet might not be possible. But you have other alternates

1. one is the drop down, where you just simply pick up the name which itself comes from other sheet.

2. you have two columns, One where you instead of typing name, type in a code and othe column would use that code to see what name is attached to that code

For option 1, see the Validation
for option 2, see VLOOKUP
0