Using info from one workbook into another???

**sbwhite0** · 12-30-2006, 11:13 AM

I must fill out a daily form that shows what I completed throughout the day.
This form has more than one page quite often,however the first page always has the total from all the sheets in the work book. Now at the end of the week I must fill out a Weekly recap of what I have done for the week. Is there any way to have the weekly recap automatically take the values from my dailys and enter them into the correct spot on my weekly workbook???

If a copy of these might help let me know I could send one. Thank you

**VBA Noob** · 12-30-2006, 12:00 PM

Hi,

Does the attached file help

or maybe this link

http://www.rondebruin.nl/tips.htm

VBA Noob

**sbwhite0** · 12-30-2006, 12:18 PM

I'm not sure if I'm not understanding of If I did not explain correctly. My dailys are sepererate workbooks. seperate from the weekly workbook.I need data from a seperate file to be entered in to my weekly. I hope this helps clear things up

**VBA Noob** · 12-30-2006, 12:19 PM

Then take a look a the link

VBA Noob

**sbwhite0** · 12-30-2006, 08:51 PM

I still can't seem to get it right.
I'm going to attach a copy of both the daily and the weekly.maybe this will help.

The cells i need to transfer are formulas for the sheet they are on. So when this VBA copys it the cells say REF!!#

VBA noob I appreciate everything I'm on the right track. It is bring over the data now. Just a little fine tunning

**VBA Noob** · 12-30-2006, 09:56 PM

Hi,

The layout looks the same. You could try sumproduct which works even when the workbook is closed.

=SUMPRODUCT(--('[Copy of 12-29-06.xls]Sheet1'!B8))

Could add the other 6 sheets with a + joinner

=SUMPRODUCT(--('[Copy of 12-29-06.xls]Sheet1'!B8))+SUMPRODUCT(--('[Next workbook name.xls]Sheet1'!B8))

However it may be slow recalc so that off autocalc which is under options

VBA Noob

**sbwhite0** · 12-30-2006, 09:57 PM

I'm going to give that a try. Thanks for the help

**sbwhite0** · 12-31-2006, 12:21 AM

all right It is bringing the info from the workbook to this page, however since the value is =sum*+* it is just adding what is in the new workbook. Is it possible to just transfer the value only, NOT the formula?for example if (sum B4;B10=12) can we have it enter 12 instead of the formula (sum B4;B10=12) ?

Please help me
Shawn White