Insert text to particular cell using VBA

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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
It's hard to work with a picture. Could you upload a copy of your file?
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top