I have produced an Excel speadsheet expense report that
requires account numbers. Each expense is listed on a
worksheet with the appropriate acount number. I have a
summary page that sums expenses by account number but
only if you manually enter the account number. Is there
a way to have Excel produce the list of accounts (they
may change every month) on the summary page and then sum
by accounts from the expense list.