Hi
Apologies if the title seems a little hazy.
I am trying to create a macro that will search for all my product codes starting with Z but have other combinations of letters after it, new ones are added but I am not necessarily informed of this.
I need the macro to keep all the Z codes and delete all the remainder, all the codes are in the A column.
I believe it needs the use of a wildcard and hopefully will be dynamic (will 'see' any new codes that are added)
Any help would be greatly appreciated.
Thanks in advance
Chris
Apologies if the title seems a little hazy.
I am trying to create a macro that will search for all my product codes starting with Z but have other combinations of letters after it, new ones are added but I am not necessarily informed of this.
I need the macro to keep all the Z codes and delete all the remainder, all the codes are in the A column.
I believe it needs the use of a wildcard and hopefully will be dynamic (will 'see' any new codes that are added)
Any help would be greatly appreciated.
Thanks in advance
Chris
