Posted by henkka on October 02, 2000 9:42 PM
Hi! problem again im my workbook is three sheets and in each one of them is the column B:B which includes part numbers. if the cell in the first sheet besides part number is blank then copy the cell from sheet3 to first one so that the part number is same
so if sheet1 b3=228855 c3 is blank find same part number from sheet3 and copy cell besides it to sheet1.
same must be done to sheet 2
and if the whole row is blank skip it and goto next row where is data.