I have a summary sheet and 11 worksheets. each worksheet has a team members
name on it .
I have on the summary sheet two coulmns column a and b
Column A Column B
Date Overs Bowled
3/01/09
10/01/09
17/01/09
etc
In Column B I want to enter a formula so that the date from column A will be
added up in all the 11 worksheets. I have tried VLOOKUP but it will not work
for all 11 worksheets . Is there a formula that I could use in colmun B to
sum all 11 worksheets.
On each Team Members worksheet I have
Column A Column B Column C Column D
Date Overs Bowled Runs Scored Balls Faced
Thank you.
--
barry