calculated reference

[vince]

I am trying to build a calculation that would change
sheet reference throught calculation

if value of cell A1 is 4 the sheet would be the one name 4

something like ='4'!C6

thanks

 

[Jack D.]

I am trying to build a calculation that would change
sheet reference throught calculation

if value of cell A1 is 4 the sheet would be the one name 4

something like ='4'!C6

thanks

Try an excel newsgroup. This one is for Microsoft project.
I think you would use a variable and some visual basic. Set it to the value
of the cell you want and then use that value to specify a range, then get
the value of that range and put it in the cell you want to put it in.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++