| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating data entry
hi guys,
I have a question regarding Excel I hope you'd be able to help me out: i'm working on inventory files,I have a receiving spreadsheet and the main inventory.Is there any way to update the quantity of the items in the main file when I receive any new item: RECEIVING FILE: col. A col.B col.C partA 20 2/2/07 partB 5 3/20/07 partC 10 3/25/07 partB 100 3/30/07 MAIN INVENTORY FILE col.A (availability) colB(qty) partA 1000 partB 100 partC 10000 I need col.B of main inventory file be updated automatically thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
| Updating data... | Excel Discussion (Misc queries) | |||
| format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
Threaded Mode
