I have scanned the posts and could not find the answer to my question. I
want to be able to insert an entire row when a new client is added. For
instance

if cell A1 is Jane Smith
if cell A2 is John Smith

and then I get a Joe Smith that should go in between those two, I want to
insert a row. This is kind of tricky because I am pulling data in from SQL.
Therefore, the new row would be determined by the results of the SQL query.
If there is a Joe Smith in the data I would then need to insert a row
starting in column B. I hope that makes sense. It is kind of complex and
maybe there is a better way of doing it. I have a spreadsheet with
conditional formatting based on the data brought in by SQL. I do not want to
mess up those cells when a new client is added. Please let me know if anyone
has any ideas.

Thanks!