I am looking for vba code that will do the following as mentioned below
File Name- Percentage.xlsx(This file is not opened so open the same by vba)
Code will be placed in test.xlsb file
I have a data in column C
If column C is above 90 then put 1% in Column G
If column C is above 80 then put 7% in Column G
If column C is above 50 then put 50% in Column G
i will add more these type of additional conditions if its required
Loop in column C and if condition met then as per condition put the data in column G
save it and close the file