Hi,
I have this workbook which has two sheets dump and Primary data,serials numbers are entered in dump sheet.Primary data sheet contain start and end serial no in column C & D respectively and distributor name in column E.
I want macro which will search for which range(column C & D of Primary data) each serial falls in dump sheet and also will provide the distributor name.
uploaded the original file from in.xls
Bookmarks