| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a sales receipt worksheet to an inventory worksheet
I have a sales receipt worksheet that has all my sales items on it. I also
have an inventory worksheet. I would like when I make a sale that it automatically is deducted from my inventory worksheet. I have Office 2003 Example: Sales receipt is (sheet 4) In each column Item#-Description-Item Cost-Qty-Cost Example: Inventory is (sheet 5) In each column Item#-Description-Cost- Qty Rec'd-Sold-In Stock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup inventory to a receipt | Excel Discussion (Misc queries) | |||
| can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
| Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
| Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) | |||
| Where find a template for a Sales receipt? | New Users to Excel | |||
Linear Mode
