I have a sheet (FirstTask) that need to be filled more then once per day (same sheet with different entries-COST). Every time when that sheet (is open (reopen to fill another entries-COST) I want to get the final result C10 and put in to a defferent WorkBook (DailyReport) in the end of the day i need TOTAL amount!... Here is the sample attached..



Thanks if somebody can help me with!

Attached Files

	DailyReport.xls (14.5 KB, 10 views)
	FirstTask.xls (13.5 KB, 8 views)

And a simple link between workbooks is not enough?
=[FirstTask.xls]Sheet1!C10 and so on...
If you don't know to create and change the links in a workbook, try these steps:
with all your workbooks open, in a cell in daily report.xls type the equal sig
n = then activate the workbook first task .xls and click cell C10 in Sheet1, then press enter ; you will have this formula in daily report: =[FirstTask.xls]Sheet1!C10 . Do the same for the other workbooks.
If you change the location of the linked work, you have to change the links to indicate the new location. In daily report, on the menu line, click on Edit-->Links ; a dialog window will show; select the source file needed, then click on change links, and browse to the location of your file, select it click ok. Whenever you open daily report, the links will be updated with the new values from source files if you make the necessary settings:
Don't ask whether to update links when I open any workbook, and update links automatically: This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs.

1. On the Tools menu, click Options, and then click the Edit tab.
2. Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed.

Don't ask to update links for this workbook, and let me control whether links are updated
Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.

1. On Edit menu, click Links.
2. Click Startup Prompt.
3. Select the option you want.

Note You will still be notified if there are any broken links.
source: http://office.microsoft.com/en-us/ex...005199380.aspx
http://office.microsoft.com/en-us/ex...005203695.aspx
Hope this answers your problem...