Find and replace cells with new figures

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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?