MD, I have some code written but I need to firstly establish which event the new data applies too and then find the last row within that particular range.

What I need to know firstly, is... does the line " Set Tgt = Cells(ActiveSheet.Columns(10.Find(What:=Event, lookat:= xlWhole).Row,1) find the correct type of event?

and secondly can I then use the offset to find the last row within this section?

Ted

BTW my apologies to Bob for the wrong example posted.