How does one auto-change values?
 

Using Excel 2007. Multiple sheets in one workbook and each containing a list
of "Questions" in column B. As each each is answered, a date is placed in
Column A next to that question. Sheet 1 in the Workbook contains a Category
list in Column A, a total for # of questions in each Category in Column B and
how many have been completed in Column C. Column D contains a formula for
displaying percentage of questions completed in each particular category.
Need to auto update Sheet 1's values. EX: As dates are entered next to Sheet
2's "Questions", the # of questions completed column on Sheet 1 would
automatically increase.

How does one auto-change values?
 

In Sheet1, enter:

=COUNT(Sheet2!A:A)

This will count the number of dates entered in Sheet2 column A
--
Gary''s Student - gsnu200791


"Darin" wrote:

Using Excel 2007. Multiple sheets in one workbook and each containing a list
of "Questions" in column B. As each each is answered, a date is placed in
Column A next to that question. Sheet 1 in the Workbook contains a Category
list in Column A, a total for # of questions in each Category in Column B and
how many have been completed in Column C. Column D contains a formula for
displaying percentage of questions completed in each particular category.
Need to auto update Sheet 1's values. EX: As dates are entered next to Sheet
2's "Questions", the # of questions completed column on Sheet 1 would
automatically increase.