I have 40 matrices, each on Sheet1 in a different workbook. Each matrix is 5
cells across by 18 cells down. Each row of data (all 18 rows) has a single
"x" in one of the five columns. I want to write a macro that will count the
number of x's at each intersection, so I would want to count the number of
times (within the 40 different workbooks) that an "x" appears in A1, A2, A3,
A4, A5, B1, B2, etc. How can I do this?
--
Thank you! - Jennifer