Good day all:
Hope you can help. I have searched some of the recent posts but can't seem to find an exact match for the help. Here is my issue, aside from not knowing how to write macros.
I have a form and here is how it works:
1. The user selects a country from the dropdown (let's say "UK").
2. The user selects the quarter which they want to fill the form out (let's say "Q1"). For us, this corresponds to Jul, Aug, Sep (which is then display in the range (E9:G9)
3. C11:C16 displays 6 products.
4. E11:G16 are empty cells that need to be filled out by the user.
5. There is a command button to add the data in cells E11:G16.
6. When the user clicks, I hope that range of data (E11:G16) gets populated in another sheet which stores the data, by country, by product and by month.
Thank you so much in advance. I will be monitoring this post and appreciate any help. Also, if you know of a similiar request, feel free to pass the link my way.
Thanks!
J
Hope you can help. I have searched some of the recent posts but can't seem to find an exact match for the help. Here is my issue, aside from not knowing how to write macros.
I have a form and here is how it works:
1. The user selects a country from the dropdown (let's say "UK").
2. The user selects the quarter which they want to fill the form out (let's say "Q1"). For us, this corresponds to Jul, Aug, Sep (which is then display in the range (E9:G9)
3. C11:C16 displays 6 products.
4. E11:G16 are empty cells that need to be filled out by the user.
5. There is a command button to add the data in cells E11:G16.
6. When the user clicks, I hope that range of data (E11:G16) gets populated in another sheet which stores the data, by country, by product and by month.
Thank you so much in advance. I will be monitoring this post and appreciate any help. Also, if you know of a similiar request, feel free to pass the link my way.
Thanks!
J