Excel 2007 : connection two workbooks

**ALEZI** · 06-01-2010, 07:51 AM

Hello guys,

I correctly making production report form, this form consist two completely different workbooks, first workbook where I planning to put my production data and second workbook where my final version of production reports.

Basically I need to connect those workbook, when I was put data into first I want automatically transfer to second workbook some of them (not all data) ,first workbook contains some columns which have two different data separated with “/”,those cells I want to show separately in my second workbook. I will try being more clear with colored cell.

Thanks guys in advance.

**NBVC** · 06-01-2010, 08:02 AM

If you can change your column A in the WK1 to show Weeknumber in each cell corresponding to the data, then you can use SUMIF, like below:

In C2 of Workbook2.

=SUMIF('First workbook'!A:A,A2,'First workbook'!C:C)

Or you can add another column in Wk1, to extract the Weeknum from column B

with formula =Weeknum(B5)-1 copied down.

**ALEZI** · 06-02-2010, 05:31 AM

Thanks for answer but me looks like you did not understand me, probably I had been confused when explained.

Basically, there we have two completely separated Excel documents (First xlsx. and Second xlsx.),how can make connection between them, when summarized data per week from first file automatically transferring to second file without entries, it is generally aspiration.
Formula from previous post work when I summarized per a week column with whole numbers (as I show in attach file), for this part my question, when I would be put data into columns E and F because there we have two tips data bars and Kilograms for each cell of those columns, I want to separate for exa. with “/” (25/56.32Kg),how when I do this Excel immediately divided those numbers ,this is entries problem, problem with transfer is because I want to take only data about bars into second document (in this case 25.

My hope is that I would be more clear than first time, any thanks all which try to help me.