M
manuelthecat
Hello,
I have the following situation:
One workbook with about 100 sheets in it. On each sheet are between 12
and 56 rows (so, they vary). One colum in each sheet holds the account
number (account #'s from 10 through 45). Each row will be given an
account number from the available account numbers in a specific column.
I'll try to draw it below:
A B
1 Port# Account#
2 500 10
3 463 11
4 322 10
5 822 9
6 333 5
and so on, but it continues for several rows and across about 100
sheets.
I'd like to have the ability to do a rollup summary sheet at the
beginning telling me how many rows belong to account# 10, how many
belong to account# 11, how many to account# 9, and so on.
I'm really not an excel guru at all, and I definitely don't know
anything about VBA code. Is there some easy way that I can do this?
Thanks,
Dave
I have the following situation:
One workbook with about 100 sheets in it. On each sheet are between 12
and 56 rows (so, they vary). One colum in each sheet holds the account
number (account #'s from 10 through 45). Each row will be given an
account number from the available account numbers in a specific column.
I'll try to draw it below:
A B
1 Port# Account#
2 500 10
3 463 11
4 322 10
5 822 9
6 333 5
and so on, but it continues for several rows and across about 100
sheets.
I'd like to have the ability to do a rollup summary sheet at the
beginning telling me how many rows belong to account# 10, how many
belong to account# 11, how many to account# 9, and so on.
I'm really not an excel guru at all, and I definitely don't know
anything about VBA code. Is there some easy way that I can do this?
Thanks,
Dave