Multi workbook summary

[nickthompson]

Hi Guys,

I am haveing real trouble trying to get excel to do a number of things. Im not bad at it but just cant work thes things out.

I have got 4 pages, 1 with PAYE, 1 with LTD, 1 with UMB and a summary form at the end. I need the forms to link into the summary at the end (which I have done for totals) but i also need it to take averages but cannot get this to work. The forms have 5 different sections (weeks) and they do not have a fixed number of entries for example week 1 has 15 and week 2 have 21 so there is no link in numbers. How do I get it to work out the averages and send the data to the summary forms??????

I can send the form to anyone who thinks they can do it.

Many thanks for the help guys.

Nick

[Bryan Hessey]

Hi Guys,

I am haveing real trouble trying to get excel to do a number of things. Im not bad at it but just cant work thes things out.

I have got 4 pages, 1 with PAYE, 1 with LTD, 1 with UMB and a summary form at the end. I need the forms to link into the summary at the end (which I have done for totals) but i also need it to take averages but cannot get this to work. The forms have 5 different sections (weeks) and they do not have a fixed number of entries for example week 1 has 15 and week 2 have 21 so there is no link in numbers. How do I get it to work out the averages and send the data to the summary forms??????

I can send the form to anyone who thinks they can do it.

Many thanks for the help guys.

Nick

Hi,

for passing data between Worksheets and Workbooks, David McRitchie's page at http://www.mvps.org/dmcritchie/excel/sheets.htm gives explanations in both Formula and VBA code styles.

For averaging items across multiple sheets, you will need to accumulate the figures that an average is calculated from and take an average of that total, you cannot 'average averages'

hth
---