I have an excel sheet that I need to code various cells based on certain conditions. I need to label these cells with text, giving them specific account information, depending on the preceding cells in the row. To do it manually is labor intensive, as there are thousands of rows.

I attached a sample sheet. Columns A - F list certain data, that will yield the proper account information in columns H-L. This is just one group of many. Is it possible to write a macro that can deliver the results in cells H3-L3, based on information in A3-F3? This is an ever growing list, so ideally, as I add more groups, I can just copy the code and add a new if statement with the new values between A-F to yield new results in H-L? If I am not clear, please let me know. Thank You. Would greatly appreciate your help!

code sampling.xlsx