Lookup date then enter inputbox quantity in various rows, VBA with named ranges help

[hlep]

I have written some code that works for what I am trying to do, but I must use #'s for cell location and lookup and would like to utilize named ranges so I avoid having to update code if I add/delete rows.

I am making "Add Head" buttons for various positions. With the code I enter a date, enter a quantity, then in the positions cell in sync with the entered date, enter the new quantity + previous months head count.

Please Login or Register  to view this content.

Attached is an example with a better explanation.

headcount example.xlsm

[hlep]

The code works when the following is true

Please Login or Register  to view this content.

Say I search for Feb-12, the code finds the date and adds the new Quantity to the previous months in the Marketing Range which is 4 rows below, but I must type "lu(4 ,1).Select". I'm tyring to write code that will find the cell that matches the date lookup without using "lu(4 , 1)". I would like to have it refer to a Named Range so I avoid having to change the code when I add/delete rows.