Greetings hwfan123,

Quote Originally Posted by hwfan123
I need to search through column "A" and when ever the data changes I need to insert a row.
Okay, that part makes sense.

Quote Originally Posted by hwfan123
For instance I would need a row between 100002447724 and 100002447725....
But this part, not so much

Can you describe what would be the factor(s) in determining where a row should get inserted, and what is the change that we are making that needs to initiate this?

Mark

PS - I'm not sure that you can go back and edit your first post after a second, but if the edit button is still available... getting rid of that long string would fix the window.