Hello,
In a sheet like the one below:
....A......B.....C
1 user1 $7 France
2 user2 $8 Canada
3 user3 $5 Italy
4 user4 $8 France
5 user5 $3 France
I want to create a code for a macro that scans for the column C, checks which users are NOT from France, and then delete the respective entire row.
Basically I want to delete the users that aren't from France and move up the remaining users to the empty rows
If the moving part is too complicated that's ok, I'm mostly interested in filtering the users.
Thanks in advance.