I hope someone out there can help!
I want to write a macro that performs the sumif function on files in which
the range changes from worksheet to worksheet. Each worksheet that contains a
variable number of rows. At the end of the worksheet, I would like to have a
macro to sumif column L through column Z (dependent on column A). One
worksheet might have 15 rows and another might have 300 rows. The criteria in
column A is text and column L through column Z is numerical : it is the
number of rows that change.