Find and replace cells with new figures

Closed
abass00 - Mar 12, 2010 at 08:01 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 12, 2010 at 04:35 PM
Hello,

I would like to creat a macro that could modify specific cells with new figues, I have 2 sheets, one is the data base from column A to G and the second the criteria as under:

A B C D E F G
SIN Ticker Name Yield BALANCED Dynamic Agressive
ABD DDD MSFT 1% 2% 3% 4%

The idea is the fields from D to G might be modified and therefore should be changed in the sheets databse
so the macro should go and find the Isin (ABD) in sheets database and replace the figures from D to G only.

That would be great if you could help me.

Thank you in advance
Karim

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 12, 2010 at 04:35 PM
So the macro should look only for one column (col A as per your example) and the and then put 1% 2% 3% 4% in columns D E F G on the main sheet if the value on col A matches with value in vol A in sheet 2?
0