Hi,

Tried searching for this on the web but couldn't find or figure out what search terms to use. I need to basically sum up a range that will repeat on every worksheet but one (a master copy worksheet that is duplicated each time). Unfortunately I don't know what the worksheet will be named by the end user. The purpose will be to create a summary sheet that totals the values from each of the worksheets.

Can this be done with a macro? As an example to the type of worksheet: User's own data would be in A1 to H50 with row1 having column fields. J1 to M1 would be the column fields to be counted up. J2 to M50 would be the count of the numbers.

Hope that makes sense - will drop in an example xls otherwise if that helps

Thanks,

Adam