View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ledge Ledge is offline
external usenet poster
 
Posts: 13
Default Advice on simple mod Req

Thanks Rob, it does work however the macro now does not pull the same
information across onto the "order" sheet.

If I could just somehow stop the entire row from populating past column
F.

rRow.EntireRow.Copy wksFound.Cells(Lrow, 1)

Appreciate your assistance