3D array maybe?

[ehasen]

Hi,

I am designing a log book in excel. In the workbook I have a "log" work sheet and a bunch of "test run" worksheets.

In the "Run" sheets data over time is inputted and then some simple calculations are made. Each Run sheet is identical in format and design but each is used for a different test sample.

The "Log" sheet is then used to directly reference those calculations on each run, so the user does not have to manually input the information. I have been referencing the different calculations by defining the ranges in each "run" worksheet manually and then entering the array formulas one-by-one on the "log" sheet.

My problem is that I sometimes need to add a new data point or change the format of the "run" sheets. When I do this I have to go back through each "run" sheet and redefine ranges and so on. Is there a way that I can duplicate any changes made in a "master run" worksheet, and have the references adjust for each subsequent "run" worksheet after that?

From what I can tell I think a 3D array might work, but Im dont know much about VBA, which I think is the only way to write a 3D array. Please let me know if you have any ideas.

Erik

 

[Al Chara]

Have you tried setting up a dynamic range? Excel has the ability to create dynamic named ranges that will expand and contract according to the data in them. There is plenty of information on this board related to dynamic ranges.

 

[Norie]

Erik

What sort of things will you be changing?

 

[ehasen]

Erik

What sort of things will you be changing?

I would be looking to possibly change the title of data values, but also add, move and delete data values as well. The "run" sheets look like a score card, where each test info is manually typed in and the info needed is sometimes changed.

Thanks!

 

[ehasen]

Thanks! Ill look into that, it sounds promising.