Select item from Drop Down list

Hi,

I am working on the case where I need to run the code, which opens the specific file, selects specific sheet, and chooses the item based on cell data from DATA Validation drop down list and closes the workbook without save.


Is it possible to do with VBA macro?

Is it possible to do with VBA macro?

Yes, It is possible in VBA Macro.
share before/After sample dummy file of your data

Hi,

Thanks for the reply.

Please find attached file with drop down list and SUMIFS based on the selected item from the list.

So to SUM up:

The code should work in the following manner: (there are two files: one with list of items to be chosen and 2nd with drop down list)

1. Look at cell value in the range in the 1st Workbook - "LIST" (sheet1)
2. Open the 2nd workbook "drop down list" with drop down list and choose the appropriate value from the list based on the value from the 1st workbook.
3. Then choose other item based on the next value from the range from 1st workbook and so on until the range will end.

hi G.Bregvadze,

Not clear the scenario, what is the input and what will be the output look like??
what is your current manual process,which you want to automate??

Hi,

The overall process is very complex and I just need the part of this process to be automated, in other words I intend to add this code to the general code.

for this case I will clarify, as mentioned above:

1. Macro should be placed in file "LIST" and after running it it should lookup to the list of products on "sheet1"
2. Open the workbook "Drop down list" and choose first item from the drop down list based on the list at "sheet1"
3. Save the workbook and leave it opened
4. Go to the "LIST" workbook, look at the next item in the list, select Workbook "drop Down List" and select item from the drop down menu based on the list

Hi there any updates for this case?