Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing data from one workbook in another.
Im using Excel 2000 and am trying to get data from one cell or a range of
cells, which may contain formulas (Im still building it), to display in a cell or range of cells in another workbook. The two workbooks are e-mailed to two different people, and are done at different times of the month. However I want information from one to be displayed in the other so that it saves time on typing and on supplies at work. The first work book is a tracking log of copier use and the other is a work book with multiple sheets, one for each day in a month. The second is a collection of data on wasted paper, and non-used completed items from the copier. What I am trying to do with the first workbook is make it be predictive by taking information from the second workbook, but a week prior, to adjust the number of completed items needed to be printed that day and reduce the amount of waste. This way better inventory tracking can be done with more efficiency. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Who has this workbook open showing previous users | Excel Discussion (Misc queries) | |||
Excel 2002 opens without showing a workbook | Excel Discussion (Misc queries) | |||
Bar Chart with bar data and another bar showing a range of data | Charts and Charting in Excel | |||
how do you make a summary page showing the workbook name with the excel sheet names | New Users to Excel | |||
Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions |