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:
Could anyone help me find a way to accomplish this?
Thank you,
Excel Noub
Bookmarks