INCREMENTAL MACRO
this is my data
COLUMN COLUMN
A B
------- ----------------
A 1%
B 2%
C 4%
D 2%
E 1%
F 2%
G 4%
H 7%
I 1%
J 2%

i want to write a macro that will add 0.01 to CELL B1 AND COPY THIS
DATA TO SHEET 2 , THEN RESET CELLB1 BACK TO ORIGINAL VALUE AND THEN
ADD 0.01 TO CELL B2 AND DO THE SAME AS ABOVE AND GO ON UNTIL ROW 10
......

IN THIS WAY I NEED TO SEE ON SHEET 2 - THE NEW DATA WITH INCREMENTS
OFF 0.01 MADE TO ALL THE VALUES IN COLUMN B ....


IS THIS POSSIBLE ?

SAM

Yes, it's possible.




--
JP

http://www.solutionsvba.com


"Sam" wrote in message
om...
INCREMENTAL MACRO
this is my data
COLUMN COLUMN
A B
------- ----------------
A 1%
B 2%
C 4%
D 2%
E 1%
F 2%
G 4%
H 7%
I 1%
J 2%

i want to write a macro that will add 0.01 to CELL B1 AND COPY THIS
DATA TO SHEET 2 , THEN RESET CELLB1 BACK TO ORIGINAL VALUE AND THEN
ADD 0.01 TO CELL B2 AND DO THE SAME AS ABOVE AND GO ON UNTIL ROW 10
.....

IN THIS WAY I NEED TO SEE ON SHEET 2 - THE NEW DATA WITH INCREMENTS
OFF 0.01 MADE TO ALL THE VALUES IN COLUMN B ....


IS THIS POSSIBLE ?

SAM