adding the value of multiple cells to a single cell using vb.net

Allanr

New Member
Joined
Mar 15, 2015
Messages
1
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
 

Forum statistics

Threads
1,082,646
Messages
5,366,737
Members
400,917
Latest member
BlueBeerR

Some videos you may like

This Week's Hot Topics

Top