hello
my system processes a few hundred individual sheets. Each sheet has over 100 cells and each sheet can be one of five distinct types. The type is in a cell on the sheet. I want to keep a total of the cell values by type. As a new sheet is processed, I want to add the values of the cells in the new sheet to the total values from the prior sheets. I can set up an array of worksheets where each worksheet in the array represents an individual type. Thus, there would be a worksheet in the array for each type. Is there a way to add the values from a new sheet to the cell values in the array of sheets? I'm looking for a way that is better than adding each individually - array_of_sheets(type_value).cellname += new_sheet.range("cellname").value.
Thanks for any help
my system processes a few hundred individual sheets. Each sheet has over 100 cells and each sheet can be one of five distinct types. The type is in a cell on the sheet. I want to keep a total of the cell values by type. As a new sheet is processed, I want to add the values of the cells in the new sheet to the total values from the prior sheets. I can set up an array of worksheets where each worksheet in the array represents an individual type. Thus, there would be a worksheet in the array for each type. Is there a way to add the values from a new sheet to the cell values in the array of sheets? I'm looking for a way that is better than adding each individually - array_of_sheets(type_value).cellname += new_sheet.range("cellname").value.
Thanks for any help
