Auto Fill Form
Hello all-
I need to create a form(Fax cover sheet) that will autofill the fax number and phone number when I type in a name. I have the data on sheet 2 that includes the name, fax number, and phone numbers in columns A, B, and C respectively. I have played around with a couple of different formulas, but have not been able to come across the correct combination. Any help would be greatly appreciated. This is a bit above my head. Thank you, Michael |
Auto Fill Form
Michael, You need a drop downlist for your names. Take this link to find ou how. http://www.contextures.com/xlDataVal01.html And then you need a VLOOKUP formula to fill in the phone and fax. T learn how take this link. http://www.contextures.com/xlFunctions02.html HT -- Case ----------------------------------------------------------------------- Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454 View this thread: http://www.excelforum.com/showthread.php?threadid=47763 |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com