Ok, lets try another way to explain my problem -
I have multiple worksheets within a workbook all with exactly the same formats and holding the same kind of data.
I want to perform a SUMIF function in a summary worksheet referencing 2 or more of the worksheets. The problem is I don't know yet which ones I need to perform the function on. I have some script that will find the worksheet names I need to use.
Would the best way be to add the worksheet names to an array and then reference this array into the SUMIF function somehow? and if so how what is the code I would need.
Thanks all
I have multiple worksheets within a workbook all with exactly the same formats and holding the same kind of data.
I want to perform a SUMIF function in a summary worksheet referencing 2 or more of the worksheets. The problem is I don't know yet which ones I need to perform the function on. I have some script that will find the worksheet names I need to use.
Would the best way be to add the worksheet names to an array and then reference this array into the SUMIF function somehow? and if so how what is the code I would need.
Thanks all