Niall,What would the script be to duplicate from the previous instance instead of from the first instance? So if you have apples in the first instance, add a row and change to oranges, how would you make sure that the oranges row copied next?Thanks!Scott

Thanks to you both for your help. Srini,my limited knowledge makes it hard for me to exactly follow your script - would I put this on the Print button or another button? Does it include the command to print if all required fields are filled in?Paul, I think yours was a little easier to follow. It se...