Help with macro to add new line items to a list

[zoog25]

Hello all,

Here is my situation. I am writing a macro for work. So far I have the macro with inputbox that takes users info and fills in a form. The thing is now they want a master list so here is what i have so far. The inputbox has four entries: Job, ProjectName, Contractor, PM. Those are the variables I am using in my first macro. Now on a sheet called job list I have the following setup.
Column A Column B Column C Column D
Job No. Project Name Contractor PM

Condensed Job List

*	A	B	C	D	E	F
193	6807	*	*	*	*	*
194	6808	*	*	*	*	*
195	6809	*	*	*	*	*
196	6810	*	*	*	*	*
197	6811	*	*	*	*	*
198	6812	*	*	*	*	*
199	6813	*	*	*	*	*
200	6814	*	*	*	*	*
201	6815	*	*	*	*	*
202	6816	*	*	*	*	*
203	6817	*	*	*	*	*
204	*	*	*	*	*	*
205	8001	NATCO (1) Unit	NATCO Group	Will M.	No	No

<tbody>
</tbody>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

As you see on top my list has a blank row between the 6000 series and the start of the 8000 series. Now what I would like the macro to do is that if the user entry into the Job variable matches any existing values in column A then it fills in columns B thru D and then asks a yes, no question to fill in Yes or No into Columns E & F. Now if the entry does not match anything then I would like it to add in a new row in the corresponding area. If its less then 8000 then it goes above the blue line otherwise, if it is greater then 8000 it goes below. Now i also would like to keep its numeric order if all possible. Thanks for any assistance.

 

[zoog25]

Can anyone help or offer an alternative to my situation.