help, formula to read results and paste to other document

[paulaskew]

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

 

[paulaskew]

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

 

[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

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

Gord Dibben MS Excel MVP

 

[paulaskew]

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,