Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking to file, some formulas work only if file is open ST Matt Links and Linking in Excel 0 February 17th 11 07:22 PM
Linking to another file using file reference typed cell Steven Excel Worksheet Functions 3 April 5th 08 03:15 AM
Linking a worksheet from a different excel file Trever B Excel Discussion (Misc queries) 1 May 11th 06 11:19 AM
Turning a text file name into a search and linking the file as a hyperlink AlistairM Excel Discussion (Misc queries) 1 January 26th 06 04:55 AM
Linking Formulas, Worksheet to Worksheet - Excel 2003 windsong Excel Discussion (Misc queries) 2 November 14th 05 01:37 AM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"