Values of cells to be routed to other sheet

Dear Leo,

I know you only can do this!!! But I also know the pain behind doing this

Rather than going through below observations, I request you to please make a new code with simple below logic

--> When Location & Dispatch Type selected in dropdownlists are equal with the headers in SSR Sheet & When I enter quantity for few models by minimizing those values by typing few of the words in cell G10 of Sheet1. Quantity to be summed up in SSR sheet.

Below are my observations & Changes are required:

Thanks for your help in advanced.

1. Please go through Columns I to L Columns where I hide the data with font. If you want to check that Please change the font from white to automatic. I think we don't require Blad1 as these columns are enough for search suggestion function in location dropdownlist

2. When I'm typing something in Location Dropdownlist, I'm getting VB Error. Can you please stop that with your valuable code

3. Column H contents are being cleared after running the code, I don't want that to happen, as it is for checking balance of the particular location after entering/summing up the quantity

4. Major thing is that when I enter quantity second time for the same location, Dispatch Type & for same model, it is over writing the quantity that has been entered first time in SSR sheet

4. I think I forgot to tell you about Models cell (Cell: G10), This makes below models list a dynamic i.e., If I type/enter something in Cell G10, below models list will be dispayed as per the value typed here. So I request you to map that models also along with location & Dispatch type

Ex: Just type 1400 in G10 cell, you can see the models with only 1400 in models list. Please enter quantity 500 in all the cells, you can observe that quantity is not being populated correctly as per models displayed

5. If I made location & Dispatch Type dropdownlists as blank, Column H from Row 14 to 48, this is being populated with numerical values I don't know where it is coming from

If anything else missed, will get back to you

Thanks Leo!!!! There is a small modification required in the code.

Call Balance button is not required as I'm trying to get the balance with simple Index formula as shown below

=IFERROR(INDEX(SSR!$B$9:$FU$42,MATCH($F14,SSR!$A$8:$A$42,0),MATCH($G$8&"BAL",SSR!$B$7:$FU$7,0)),"")

Replace Quantity button should be just Quantity, as I'm trying to add the quantity with the existing quantity rather than replacing.

So request you to please make changes and do the needful.