mathsbeauty
Board Regular
- Joined
- Apr 23, 2011
- Messages
- 89
Hello! I am new here. I am learning macros in excel. I am stuck with the following situation. I need macro which:
i) Shows column C and D.
ii) Shows column F. But those cells in this column which contains "A", "B" or "C" in the column A's corresponding cells are hidden.
iii) All other columns are hidden.
Thus the problem is to hide all columns except C, D and F and to hide those cells in F which contains "A", "B" or "C" in the corresponding cells of column A. The key here is how to autofilter column F based on corresponding entries of column A.
I hope to get some help from experts. I will be really thankful for the help that I may get.
i) Shows column C and D.
ii) Shows column F. But those cells in this column which contains "A", "B" or "C" in the column A's corresponding cells are hidden.
iii) All other columns are hidden.
Thus the problem is to hide all columns except C, D and F and to hide those cells in F which contains "A", "B" or "C" in the corresponding cells of column A. The key here is how to autofilter column F based on corresponding entries of column A.
I hope to get some help from experts. I will be really thankful for the help that I may get.
