alinaim1357
New Member
- Joined
- Oct 23, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
i have table consists of students name,class,major, phone number and etc in sheet 1
then i want user in sheet 2 write class number in cell a1 and then all student name which are in written class appear in column b
i use advance filter but the problem is i cant load just students name without class and other columns in table
is there any way to filter like this with vba or without ?
unfortunately in my problem i shouldn't use pivot table.
then i want user in sheet 2 write class number in cell a1 and then all student name which are in written class appear in column b
i use advance filter but the problem is i cant load just students name without class and other columns in table
is there any way to filter like this with vba or without ?
unfortunately in my problem i shouldn't use pivot table.