LittleMiki
New Member
- Joined
- Aug 5, 2019
- Messages
- 1
Hi all,
I am trying to create a report for our marketing department to fill in figures on an ad-hoc basis.
I have this idea in my head which I hope you can help with.
Basically, I would like to know how to do the following:
Based on what the user selects in the blue cells (using Data Validation selections) and what the user subsequently types into the green cell - I want that value to go into the corresponding cell in the blank tables shown on the right when they click the Submit button.
Image here
So for example, if the user enters 5000 as the value for May 2020, for Manufacturer 1/Category 2 it would look like the following:
Image here
Thank you for your help in advance.
LM
I am trying to create a report for our marketing department to fill in figures on an ad-hoc basis.
I have this idea in my head which I hope you can help with.
Basically, I would like to know how to do the following:
Based on what the user selects in the blue cells (using Data Validation selections) and what the user subsequently types into the green cell - I want that value to go into the corresponding cell in the blank tables shown on the right when they click the Submit button.
Image here
So for example, if the user enters 5000 as the value for May 2020, for Manufacturer 1/Category 2 it would look like the following:
Image here
Thank you for your help in advance.
LM