vzachin
08-01-2006, 06:53 PM
I have a data sheet with part numbers and mfg codes that i am downloading from a main frame database. the data contains 2 columns and will have at least 1 row, no more that 10000.
this is a 2-fold question.
the data in column A are 11 characters long.
i need to find all the part numbers with a "K" in the 9th position and a "0","3","4" or "6" in the 10th position. i want to move this data to the bottom of all my data, separated by a blank row.
the last row of data contains 11 dashes in column A and 4 dashes in column B.
i want to remove these dashes.
the way i handle this now is to put a formula in column H to find the part numbers, sort and then cut & paste to the end.
i started recording a macro but got stuck writing the formula. there must be an easier way.
thanks
vzach
this is a 2-fold question.
the data in column A are 11 characters long.
i need to find all the part numbers with a "K" in the 9th position and a "0","3","4" or "6" in the 10th position. i want to move this data to the bottom of all my data, separated by a blank row.
the last row of data contains 11 dashes in column A and 4 dashes in column B.
i want to remove these dashes.
the way i handle this now is to put a formula in column H to find the part numbers, sort and then cut & paste to the end.
i started recording a macro but got stuck writing the formula. there must be an easier way.
thanks
vzach