Hi guys, I have challenge in my work , can anyone have any idea about it please suggest me,
Im looping each record based on part number,reading units and looking available units in another sheet and if I found I'll write units in that cell and if still available units in that part number, pick second part number and need to check units are available or not if avilable then second part number available units also need to enter in first part number column, if not available in first PN then need to enter in second part number , continue for the same in remaining parts also .