Give us a clearer view of how the data is set out in each sheet.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Rebecca Bauer" wrote in message
...
Sheet 1 is all the attendance data for Directors that are subtotaled by
type
of Committee Meeting attended. Sheet 2 is one Director. I would like to
take the subtotals from one Director in Sheet 1 and annotate them in Sheet
2
by putting in the cell address of the forumula from Sheet 1 into Sheet 2.
So
as I increase the number of meetings attended in Sheet 1, Sheet 2 will
automatically update. Can I do this?

Beccy