| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help!! using sheet 1 information to change information on sheet 2
On sheet one I have all Company Names in column A, Addresses in column B and
City & State on column C. On a form I created on sheet two (example) A B C D E 1 Company Name: 2 Address: 3 City & State: 4 When I type the companies name on B1, I want B2 & B3 to change automatically using the reference on sheet 1. So next time I change the company name the other cells B2 & B3 will change because the B1 cell changed. Thank you for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checkbox, then taking information from one sheet to another sheet | Excel Worksheet Functions | |||
| Information copying from sheet 1 to sheet 2 | Excel Discussion (Misc queries) | |||
| Sheet Information - Is sheet protected? | Excel Discussion (Misc queries) | |||
| How do I automatically get information from sheet 1 into sheet 2 | Excel Discussion (Misc queries) | |||
| Reference information from one sheet to a second sheet | New Users to Excel | |||
Threaded Mode
