when you say you "only need to see" B,C and D, and then, "only need to see" E,F and G, do you mean that you want the columns BC and D to be hidden, i.e. actually not present on screen, if the appropriate value is entered in col A?
What do you want to be visible while you are actually making the entry?
I suspect that what you really need is a macro that make the selected cell jump from col A to col E for a given entry, or from col A to col B for a different entry... in order to make entering data easier. Am I correct?