looping calculation in 4 sheets

[varshneybhasker]

hey everyone...my pblm is a bit big..so i need really an xpert help.

Description:

1. i have 5 sheets named SPECS, PULL, MATCH, SUMMARY1 & SUMMARY2 in order.
2.in SPCES i input some values...those values get reflected in PULL sheet.in PULL sheet certain formulas & programming is done to calculate a value.I have made a button in PULL sheet which copies all the inputs & outputs to the SUMMARY1 sheet.
3.next, i go to MATCH sheet (takes inputs from PULL sheet) & click a button to add inputs & outputs to the SUMMARY2 sheet.
4.in PULL sheet i select the speed (an input) say 1 {from the drop down menu (data validation) i have created} & add data to SUMMARY1 den i do the whole above mentioned procedure of step 3
next time i select speed 2 & repeat the above procedure.
den i select 3 nd so on upto lets say 10 times.
finally a chart is generated using the outputs corresponding to 10 different speeds.

What I want

i wish to have a code which automatically got to PULL sheet select speed 1 from the drop down menu adds data to SUMMARY1 go to MATCH sheet adds data to SUMMARY2...then go to PULL sheet select speed 2 & repeats the procedure lets say 10 times.
can this be done ??


Please look into my problem patiently and rply soon.

Thanx in advance




Bhasker

[Sadath31]

Assume that your data validation in PULL sheet in range A1
then the code will be (change the code as per your requirement)

Please Login or Register  to view this content.

[varshneybhasker]

hey sadath,...thanx 4 ur concern...
the data validation in range A1 takes values from say P1:P10
next, lets say P1 is selected, then values in 2 cells below range A1 (A2 & A3) also changes according to data validation cell value.
so how to tackle this ?