I have a 3 dimensional graph on one sheet and have used another sheet in the same file to set up and solve a complex multi-step problem involving both open and close formed equations in order to fill in the graph. I basically want to use that sheet as a "calculator", or rather a class if I'm thinking of it in terms of object-oriented data structures. I want to be able to alter the 2 independent variables of the 3 dimensional graph on one sheet and have the graph call on the "calculator class" to perform the necessary operations to arrive at a dependent variable. Is there a way to tell excel to treat a worksheet like a class? I don't want the calculating class to hold any actual variables, but rather just be a road map of operations to perform on data that it is given from another sheet. Any time I change the independent variables of the 3d graph, I want those variables to be fed through the calculating sheet and give me the dependent variable in the chart.
Thanks and let me know if there's anything you want me to clarify.
Bookmarks