Changing Content in one coulumn using given content in another
Hi All
I have a small puzzle.
In one column , I have a list of various components , many of which
appear multiple times. In another , I have a list of their prices.
I need a small routine which will ask via popup for the column and
identify a particular component in it.
Then a new price for the chosen components will be requested and each
changed accordingly in the second column.
For example ;
Before
a 2.50
b 3.60
c 11.56
d 6.35
a 2.50
b 3.60
c 11.56
d 6.35
a 2.50
b 3.60
c 11.56
d 6.35
After ( component a is chosen , new price is 4.85)
a 4.85
b 3.60
c 11.56
d 6.35
a 4.85
b 3.60
c 11.56
d 6.35
a 4.85
b 3.60
c 11.56
d 6.35
Other prices for other components will be unaffected.
Can someone help?
Best Wishes
|