Arrange cells in ascending order

can someone help me . i am completely new to macros and all , came here jumping looking for help on my topic

i have added few combinations of medicines in multiple columns , i want them to be auto arranged alphabetically as i keep on adding more formulas around 1000 in near future .
i would like column c and column d or may be all to be formatted automatic counting columns c as the main column (which we take as a starting point )
help