Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Worksheet File
I am interested in keeping a 'running tab' of income (Similar to a Daily Sales Sheet), in Excel2002. How do I have the 'Daily Sales' Workbook keep track of each individual item being sold? The sale price is located in the same cell every time, however it will need to link it to different files (For different customers) and keep a total for a store report at the end of the day. Is it possible to have a formula that takes the price of each sale (Keeping in mind their in the same cell ex. b24, but named after different clients) and adds it for a daily total? Please post if need more information for my question...Thanks...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to file, some formulas work only if file is open | Links and Linking in Excel | |||
Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
Linking a worksheet from a different excel file | Excel Discussion (Misc queries) | |||
Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) |