| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get data to automatically update using a master sheet?
I have an Excel 2003 workbook for an inventory project with 1 tab showing all
the movement of various products over the last year. There is a column for the amount of said product being originally put in, a sum column which shows the amount still left in this location, and a sold column where I put negative numbers for the amount of that product sold out of said location. I would like to set up a "Dead" tab where data is transferred to when a negative number is put in this sold column. Is this possible, and how can it be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for automatically entering information from a master sheet | Excel Discussion (Misc queries) | |||
| Copy and paste cahrt to new sheet-update data automatically? | Charts and Charting in Excel | |||
| Automatically add records from a new sheet to master sheet | Excel Discussion (Misc queries) | |||
| Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
| Copying (Master) column to another sheet to automatically update | Excel Worksheet Functions | |||
Hybrid Mode
