M
Metallo
Hi,
I have two WS, say WS1 and WS2
WS1
A B C D E
1 GARY MIK JOHN 1000 700
2 GARY SANDY BRIAN 500 300
The data in column D & E are values that a user inputs.
When the user inputs D1, I want 1000 to go to WS2 where at row level the
same 3 constants can be found.
So, 1000 should go where in WS2 there are rows with the three words GARY,
MIK, JOHN.
WS2
C D E F G
1 ANDY ELLEN KEVIN
2 GARY SANDY BRIAN
3 GARY MIK JOHN 1000
In this way any value that the user inputs in WS1 D or E columns will go
automatically into WS2 where the three combination of values are found at row
level.
Please, bear in mind that although the WS1 columns D and E and WS2 columns F
and G have respectively the same heading name.
Once again, if user enters in WS1 the value for E2, then 300 should
automatically end up into WS2 G2.
I dont't know if this can be done programmatically or by a particular fx
function in Excel, but I'm sure you can help.
Thank you
Metallo
I have two WS, say WS1 and WS2
WS1
A B C D E
1 GARY MIK JOHN 1000 700
2 GARY SANDY BRIAN 500 300
The data in column D & E are values that a user inputs.
When the user inputs D1, I want 1000 to go to WS2 where at row level the
same 3 constants can be found.
So, 1000 should go where in WS2 there are rows with the three words GARY,
MIK, JOHN.
WS2
C D E F G
1 ANDY ELLEN KEVIN
2 GARY SANDY BRIAN
3 GARY MIK JOHN 1000
In this way any value that the user inputs in WS1 D or E columns will go
automatically into WS2 where the three combination of values are found at row
level.
Please, bear in mind that although the WS1 columns D and E and WS2 columns F
and G have respectively the same heading name.
Once again, if user enters in WS1 the value for E2, then 300 should
automatically end up into WS2 G2.
I dont't know if this can be done programmatically or by a particular fx
function in Excel, but I'm sure you can help.
Thank you
Metallo