Hi, gowtham_pec,
starting with the secon question you could change the code like this:
IŽd comment the other part in the code out first.
For the first question: as you copy entire rows but have two different ranges on each sheet you can either break up the code into another small loop or two command checking each last row in each range and copy or stay with this procedure and delete the empty rows from Master for Orders near the end of the macro like
And AFAIK the codes you have donŽt belong behind Sheet Start but should go into a normal module.
Ciao,
Holger
Bookmarks