arnab0711
05-17-2012, 01:01 AM
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.
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.