I am currently working on an excel tool (more use to access and am a tad out of my depth) that allows the user based upon a selection in a combo box (and activated by a command button) to copy the matching entry (say situated in coloumn B rows 1:100)within another sheet (Sheet2) and populate an action plan list within the sheet the combo box is situated (sheet1). 

The idea is that the first selection would put an entry in say Cell B5 and then on further selections B6, B7 etc.  Its important that this is copied as I am using the comments attached to these cells as an explanatory note supporting the action. 

What I want to do is to enable entries to be added to a continous list.  I would also like the reverse functionality i.e. to select an action from the combo box and delete the entry (row) from the continous form below via a delete command button.

 If anyone can help be much appreciated.

 Kev