vba or formula help?
 

Hello

I have the following data
Année V1 V2 V3 National
1992 14805 100
1993 16521 2640 120
1994 17839 2142 117
1995 19878 1236 1207 136
1996 12456 1024 140
1997 14526 1563 1274 152

I want to calculate an "'indice" with vba or a formula

example: to obtain these news values

Année V1
1992 (14805 *100)/14805
1993 (16521*100)/14805
1994 17839 *100)/14805
1995 19878 *100)/14805
1996 12456 *100)/14805
1997 14526 *100)/14805

Année V2 V3
National
1992
100
1993 (2640*120)/2640 120
1994 (2142*117)/2142 117
1995 (1236*117)/2142 (1207*120)/2640 136
1996 (1024 *117)/2142 140
1997 (1563 *117)/2142 (1274*120)/2640 152




How do?
Excel version xp/2003

Mike
Excuse my english

vba or formula help?
 

Hi Mike;

I am writing asuming that V1, V2 & V3 are in seperate
columns A, B & C. I am also asuming the activecell is in
column D.

On way to do it in VBA is

Activecell = Activecell.Offset(0,-3)*100/Activecell.Offset
(0,-2)

I hope that helps

-----Original Message-----
Hello

I have the following data
Année V1 V2 V3
National
1992
14805 100
1993 16521
2640 120
1994 17839
2142 117
1995 19878 1236 1207
136
1996 12456
1024 140
1997 14526 1563 1274
152

I want to calculate an "'indice" with vba or a formula

example: to obtain these news values

Année V1
1992 (14805 *100)/14805
1993 (16521*100)/14805
1994 17839 *100)/14805
1995 19878 *100)/14805
1996 12456 *100)/14805
1997 14526 *100)/14805

Année V2 V3
National
1992
100
1993
(2640*120)/2640 120
1994
(2142*117)/2142
117
1995 (1236*117)/2142
(1207*120)/2640 136
1996 (1024
*117)/2142 140
1997 (1563 *117)/2142
(1274*120)/2640 152




How do?
Excel version xp/2003

Mike
Excuse my english



.

vba or formula help?
 

Again? What is the matter?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike Perchoir" wrote in message
...
Hello

I have the following data
Année V1 V2 V3 National
1992 14805 100
1993 16521 2640 120
1994 17839 2142 117
1995 19878 1236 1207 136
1996 12456 1024 140
1997 14526 1563 1274 152

I want to calculate an "'indice" with vba or a formula

example: to obtain these news values

Année V1
1992 (14805 *100)/14805
1993 (16521*100)/14805
1994 17839 *100)/14805
1995 19878 *100)/14805
1996 12456 *100)/14805
1997 14526 *100)/14805

Année V2 V3
National
1992
100
1993 (2640*120)/2640 120
1994 (2142*117)/2142 117
1995 (1236*117)/2142 (1207*120)/2640 136
1996 (1024 *117)/2142 140
1997 (1563 *117)/2142 (1274*120)/2640 152




How do?
Excel version xp/2003

Mike
Excuse my english