Palon
11-16-2014, 12:01 PM
Hi all,
I want to be able to select all the cells in a single column which contain string of numbers - if the first two numbers correspond to criteria provided eg. in the column below I would like to have cells with values beginning with 81 selected.
8144751
5202847
5401927
8100898
8922131
2700299
I have tried recording a macro using the filter option but that works only if I am only dealing with the same set of data. For me it's different every day so I need a versatile and simple piece of code.
Using excel 2010.
Help is much appreciated. Thank you :-)
I want to be able to select all the cells in a single column which contain string of numbers - if the first two numbers correspond to criteria provided eg. in the column below I would like to have cells with values beginning with 81 selected.
8144751
5202847
5401927
8100898
8922131
2700299
I have tried recording a macro using the filter option but that works only if I am only dealing with the same set of data. For me it's different every day so I need a versatile and simple piece of code.
Using excel 2010.
Help is much appreciated. Thank you :-)