Using spin button and taking values from another excel sheet - Question revised

Question

Hi,

 

I have an excel sheet in which i have values for eg. as shown below.

 

                                                                Percentage

Year   

                    20       21       22       23       24     25 ..........................

---

 

    1          .1       .12       .13      .14      .15    .16

    

     2         .2       .21       .22      .23      .24     .25

 

     3        .3         .31      .32     .33       .34     .35

  

     4        .4         .41       .42     .43      .44     .45

 

     5        .39        .5        .34      .45     .56       .78

 

---

In another excel file

 I have a spin button targetted to a cell that contain these percentage values and another row  contain the year values. When i change the spin button the percentage values will change between 20-30 for eg.

that time the decimal  values for year also must change-means the correspondind decimal values for year 1,2,3,4,5 should be taken automatically from the first excel for each percentage value 20,21,22......30 as the percentage value changes when i click on the spin button (these values should come from different excel sheet)

 

 

 

23	23	23	23           23	23   (this value will change as the spin button changes )
1	2	3	4	5

 

.14       .23            .33          .43              .45     this value should change accordingly and should come from another work sheet)

 

How can i do this in excel? can anybody help?

 

 

 

 

       

Answer 1

This is the Excel Services forum - you want the Excel forum (Excel client)