Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have created a form in excel and an address book on a separate worksheet.
The form is a basic contract for advertising and I have a field for contract number and then fields for the name and address of the company that contract number belongs to. I want to be able to say "if the contract number is "x," populate the name and address fields with the corresponding information from the name and address list on the second worksheet." I have tried all sorts of tricks, but nothing is working. Any thoughts? Thank you so much. -- Deborah |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions |