Shines0012
New Member
- Joined
- Apr 2, 2020
- Messages
- 3
- Office Version
- 2019
- Platform
- MacOS
I am trying to input data from my UserForm into a sheet I have already entered data without using the UserForm. For example, I have "Date", "Customer" in a drop down box , "Product" in a drop down box, "Quantity" , "Sales Price" As my data in the Userform. In my sheet, "Sheet 4", I have as headers, "Price" "Customer" "Product" "Quantity" "Sales Price" and "Total". My first empty row is 32 and I would like for the "Total" box on the sheet automatically generate to (6*Quantity) * Sales Price. I Can't figure out the code to transfer date from the userform to the sheet.
In addition, there are different sales prices for different products and I would like that to automatically generate in my userform. What would be the code to determine that?
For example, "That Green Drink" is $12.00 and "Energizing Elixir" is $10.00. How would I make sure those prices pop up in respect to the correct product?
In addition, there are different sales prices for different products and I would like that to automatically generate in my userform. What would be the code to determine that?
For example, "That Green Drink" is $12.00 and "Energizing Elixir" is $10.00. How would I make sure those prices pop up in respect to the correct product?