Hi,
I have been stuck with this problem for quite some time now and with the solutions I have found and adapted I have had no luck.
Intention:
"- In an AutoFilter select all values EXCEPT 58 of values (text) which I define
1st attempt:
- Have the macro create a new column and assign a number 0 to all rows I define and 1 to all values not in my list
2nd attempt:
- Adapt the macro formula to include all 58 values:
When i try to paste in the values something goes wrong and I cannot get it to delete these quotation marks:
Where what I want it to do is:
Any help would be very much appreciated and would save me a lot of frustration.
Bookmarks