I am writing a Macro to auto format, and sort an export from a data base. I am running into a problem trying to filter item number and placing them on their own worksheet.
I need to separate out the the following;
BL100, BL102, BL104, from BL1000, BL1005, and etc. I am having this problem in several areas.
I have tried filtering BL10*, and BL100*, however I am still getting all item numbers stated above.
Bookmarks