UserForm Data Save With Selected Columns

[AsifShah]

Asallam-0-Alaikum
Hello Everyone

I have created a userform for my invoice data save through userform. Each product space in the file is already created.
Some Product Name: RGB COKE, 1500ML SPRITE, 1000ML FANTA..... other you can see in sample file.
Now i want to save My product Qty "TextBox6" on that selected columns
If Textbox1.Value = RGB Coke than my Qty "Textbox6" data will save Excel Sheet RGB Coke Column
If Textbox1.Value = 1500ml Sprite than my Qty "Textbox6" data will save Excel Sheet 1500ml Sprite Column
If Textbox1.Value = 1000ml Fanta than my Qty "Textbox6" data will save Excel Sheet 1000ml Fanta Column

Please Help Its most Important for me

[davesexcel]

Use find to find the column, then get the first empty row, this will get your cell reference.
cells(row,column)

Please Login or Register  to view this content.

[AsifShah]

Dear Friend Thanks For Your Reply
you code is working for save data par Selected Columns
But it not break row when i enter new entry.

Kindly check this my new Sample file .. Please provide code for this UserForm Save Button.