Excel Customer Form - Tilted Forum Project Discussion Community

cade09 · 12-02-2003, 05:32 PM

does anyone know if there is a way to set up an excel sheet so if i type in a customer name, the information pertaining to it shows up. This is what I mean. I am doing it in Microsoft Excel

Say I type in John Deere
I want it to make the address, phone number, contact, fax#, and other information to automatically appear.
Is this possible to do.
I hope you understand what I am trying to say. Thank you in advance

poof · 12-02-2003, 06:12 PM

That would be very possible!

You could format the columns for the size of the font that would work with the same size used for the rows, or narrow the rows, then enter a header and font for each column, size each column, enter a formula that tells the cells (yr u) locked into using excell?

There are several utilities and major programs out there to do this. Don't recreate the wheel my friend.

poof · 12-02-2003, 06:55 PM

Maybe if you gave more criteria.

There are several database guru's on the TFP.

I am not one.

12-02-2003, 05:32 PM	#1 (permalink)
cade09 Upright	Excel Customer Form does anyone know if there is a way to set up an excel sheet so if i type in a customer name, the information pertaining to it shows up. This is what I mean. I am doing it in Microsoft Excel Say I type in John Deere I want it to make the address, phone number, contact, fax#, and other information to automatically appear. Is this possible to do. I hope you understand what I am trying to say. Thank you in advance __________________ Stephen Cote

12-02-2003, 06:12 PM	#2 (permalink)
poof Psycho	edit That would be very possible! You could format the columns for the size of the font that would work with the same size used for the rows, or narrow the rows, then enter a header and font for each column, size each column, enter a formula that tells the cells (yr u) locked into using excell? There are several utilities and major programs out there to do this. Don't recreate the wheel my friend. Last edited by poof; 12-02-2003 at 06:52 PM..

12-02-2003, 06:55 PM	#3 (permalink)
poof Psycho	Maybe if you gave more criteria. There are several database guru's on the TFP. I am not one. Last edited by poof; 12-02-2003 at 07:10 PM..