help, formula to read results and paste to other document

[[email protected]]

have document labeled for each week, within this there are 6 sheets,
mon/tues/wed/thurs/fri/total

i want the total for each person to be put into a other excel document,
is this possible ??

if so how ?

[Gord Dibben]

A "document" is a workbook/file?

"each week" means how many weeks? 52 for a year?

Each workbook has 6 worksheets?

"each person" is situated where within the above configuation?

On one of the 6 sheets within the 52? workbooks?

On all of the 6 sheets in each workbook?


Gord Dibben MS Excel MVP


On 20 Aug 2006 14:20:49 -0700, [email protected] wrote:

>have document labeled for each week, within this there are 6 sheets,
>mon/tues/wed/thurs/fri/total
>
>i want the total for each person to be put into a other excel document,
>is this possible ??
>
>if so how ?

[[email protected]]

There are approx 10 people
by document mean file/workbook
yes there would be 52 weeks for the year
each workbook has 6 worksheets
each person is on all 6 of the sheets

so it would be

monday
paul sold 3
bob sold 5

tuesday paul sold 1
bob sold 0

etc

total
paul sold 4
bob sold 6,
also has other stuff, but that is the main jist of it all

>
> "each person" is situated where within the above configuation?
>
> On one of the 6 sheets within the 52? workbooks?
>
> On all of the 6 sheets in each workbook?
>
>
> Gord Dibben MS Excel MVP
>
>
> On 20 Aug 2006 14:20:49 -0700, [email protected] wrote:
>
> >have document labeled for each week, within this there are 6 sheets,
> >mon/tues/wed/thurs/fri/total
> >
> >i want the total for each person to be put into a other excel document,
> >is this possible ??
> >
> >if so how ?

[Gord Dibben]

Assume week1 workbook with monday to friday sheets and a total sheet.

Each sheet has a couple of columns.

Name column and sold column.

Paul is in A2 and what he sold is in B2

On total sheet you have 2 columns.

Names and sold totals.

Paul is again in A2

On total sheet enter in B2 =SUM(Monday:Friday!A2)

That would give you a Paul total for the week.

You could link that total to another Excel workbook.

There is more, but that is the jist of it.


Gord


On 20 Aug 2006 15:17:21 -0700, [email protected] wrote:

>
>There are approx 10 people
>by document mean file/workbook
>yes there would be 52 weeks for the year
>each workbook has 6 worksheets
>each person is on all 6 of the sheets
>
>so it would be
>
>monday
>paul sold 3
>bob sold 5
>
>tuesday paul sold 1
>bob sold 0
>
>etc
>
>total
>paul sold 4
>bob sold 6,
> also has other stuff, but that is the main jist of it all
>
>>
>> "each person" is situated where within the above configuation?
>>
>> On one of the 6 sheets within the 52? workbooks?
>>
>> On all of the 6 sheets in each workbook?
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>> On 20 Aug 2006 14:20:49 -0700, [email protected] wrote:
>>
>> >have document labeled for each week, within this there are 6 sheets,
>> >mon/tues/wed/thurs/fri/total
>> >
>> >i want the total for each person to be put into a other excel document,
>> >is this possible ??
>> >
>> >if so how ?

Gord Dibben MS Excel MVP

[[email protected]]

thats what i got set up at the moment, what i want now is to be able to
put the total amount paul has sold each week into a new workbook, so
you have a workbook for each week, then one for the year, so you can
see how many ech person sold etc,


Gord Dibben wrote:
> Assume week1 workbook with monday to friday sheets and a total sheet.
>
> Each sheet has a couple of columns.
>
> Name column and sold column.
>
> Paul is in A2 and what he sold is in B2
>
> On total sheet you have 2 columns.
>
> Names and sold totals.
>
> Paul is again in A2
>
> On total sheet enter in B2 =SUM(Monday:Friday!A2)
>
> That would give you a Paul total for the week.
>
> You could link that total to another Excel workbook.
>
> There is more, but that is the jist of it.
>
>
> Gord
>
>
> On 20 Aug 2006 15:17:21 -0700, [email protected] wrote:
>
> >
> >There are approx 10 people
> >by document mean file/workbook
> >yes there would be 52 weeks for the year
> >each workbook has 6 worksheets
> >each person is on all 6 of the sheets
> >
> >so it would be
> >
> >monday
> >paul sold 3
> >bob sold 5
> >
> >tuesday paul sold 1
> >bob sold 0
> >
> >etc
> >
> >total
> >paul sold 4
> >bob sold 6,
> > also has other stuff, but that is the main jist of it all
> >
> >>
> >> "each person" is situated where within the above configuation?
> >>
> >> On one of the 6 sheets within the 52? workbooks?
> >>
> >> On all of the 6 sheets in each workbook?
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >>
> >> On 20 Aug 2006 14:20:49 -0700, [email protected] wrote:
> >>
> >> >have document labeled for each week, within this there are 6 sheets,
> >> >mon/tues/wed/thurs/fri/total
> >> >
> >> >i want the total for each person to be put into a other excel document,
> >> >is this possible ??
> >> >
> >> >if so how ?
>
> Gord Dibben MS Excel MVP