If I understood him correctly he already said some single entries were two
rows and there are blank rows between entries. So I am not sure sorting
would be advised if this is a form for interacting with the user.

But I could be wrong.

--
Regards,
Tom Ogilvy

Mark Bigelow wrote in message
...
If sorting wouldn't mess up your data, I would sort all the columns,
including H:J, by H, then by I, then by J. That way, you can start at
Row 1 through the last row of H that has data and put that Range into
the worksheet corresponding with H, then go from that last row + 1 to
the last row in I, etc...

Let me know if that doesn't work.

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!