S
Steve
i have 30 different workbooks,
each workbook has >20 individual sheets.
i have a list with two columns, one is the name of the
workbooks, and one is the name of each sheets.
here is what i want to do.
i want to do a count on 'column z' on every sheets.
(column z on every sheets has n number of data, i want to
count how many.)
ie,
column a column b column c
(sheets) (workbooks) (number of data point)
-------- ----------- ----------------------
g-1 a.xls =count('[a.xls]g-1'!$z:$z)
g-2 a.xls =count('[a.xls]g-2'!$z:$z)
g-3 a.xls =count('[a.xls]g-3'!$z:$z)
g-4 b.xls =count('[b.xls]g-4'!$z:$z)
g-5 b.xls =count('[b.xls]g-5'!$z:$z)
..
..
..
since, i have 30 workworks and each has more than 20
sheets.
the above list will have > 600 rows.
is there a easy way to put a formula in 'column c' above,
so that it will use 'column a' and 'column b' as references
and i don't have to manually type in that formula
in 'column c' >600 times.
thx in advance.
each workbook has >20 individual sheets.
i have a list with two columns, one is the name of the
workbooks, and one is the name of each sheets.
here is what i want to do.
i want to do a count on 'column z' on every sheets.
(column z on every sheets has n number of data, i want to
count how many.)
ie,
column a column b column c
(sheets) (workbooks) (number of data point)
-------- ----------- ----------------------
g-1 a.xls =count('[a.xls]g-1'!$z:$z)
g-2 a.xls =count('[a.xls]g-2'!$z:$z)
g-3 a.xls =count('[a.xls]g-3'!$z:$z)
g-4 b.xls =count('[b.xls]g-4'!$z:$z)
g-5 b.xls =count('[b.xls]g-5'!$z:$z)
..
..
..
since, i have 30 workworks and each has more than 20
sheets.
the above list will have > 600 rows.
is there a easy way to put a formula in 'column c' above,
so that it will use 'column a' and 'column b' as references
and i don't have to manually type in that formula
in 'column c' >600 times.
thx in advance.