Mar 12, 2010 at 08:01 AM
Posts4479Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Mar 12, 2010 at 04:35 PM
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.
Posts4479Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022767 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?