| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto fill Adjacent cells
I'm trying to create an an invoice/receipt worksheet, so that when I input a
number in a cell, the adjacent cells automatically fill using predefined information. For example: If i input 1234(item no) into cell A1, I want a description to appear in cell B1 and a Price in C1. If anyone knows how to do this, please could you explain in Laymens terms as Im new to all this. Many thanks and any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto fill series between to non-adjacent cells | Excel Discussion (Misc queries) | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| Fill cells if adjacent cell match criteria | Excel Discussion (Misc queries) | |||
| How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
| Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
Threaded Mode
