Excel 2003
VB 6.5
I would like to calculate the Standard Deviation (STDEV) for a series of values. These values can be on a variable number, N, of Tabs in a Workbook. Attached is a spreadsheet that shows data, in this case for N=2 Tabs. The STDEV is to be calculated on the Nth + 1 Tab called "Summary" in cell B3. Is there a VBA statement, or series of statements that will make this calculation?
For example if there was only data on one Tab, the formula in cell B3, after executing the statement would look like the following:
=STDEV(Inventory340_1!B5:G16,), and if there were two Tabs of data the formula in cell B3, after executing the statement would look like the following:
=STDEV(Inventory340_1!B5:G16,Inventory340_2!B5:G16)
The $64,000 question is what statement(s) is required for N Tabs of data.
I'm hoping to avoid a scenario where I have to cut and paste each set of data and place on one Tab, then perform the STDEV calculations.
Bookmarks