Good day,
Just got blown away by this, I need to incorporate a method that seams so easy yet I am stuck finding the how to start lol

This is my situation:

I have a 2 sheets. One with data entry and one that will act like a vblookup. I cannot post this worksheet as to much information (confidential) if I post an empty sheet beats the purpose as the info inserted generates a listbox.

I will post my code after. I have to insert a new data row... I have, based on selection, information that will be transfered from Sheet2 to sheet1 (Transposing itself in a new row) I can also have multiple selection withing this Listbox and the information will skip a row then add the next "Clicked" data that I choose in my sheet1.

I need to add a search or something that will generate a InputBox for each selection and ask for the total amount then add itself below the information, skip a row and do this if I select multiple items from the listbox until end.

Here is my code: On my Sheet1 I have a command button. Once clicked a UserForm will generate:

Please Login or Register  to view this content.


Could anyone help me find a way to accomplish this?

Thank you,

Excel Noub