| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up data from one sheet
I want to type in a material number in cell A1 on sheet 1 and have the
information from cells A1:A3 on sheet 2 populate cells A2:A4 on sheet 1. ex. sheet 1 cell A1 is blank sheet 2 A1=200209 A2=CLOSURE A3= TH I WANT THIS INFORMATION TO POPULATE ON SHEET 1 WHEN I TYPE IN THE MATERIAL NUMBER. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
| pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions | |||
Threaded Mode
