Please send me code to the following example:
There is a column with dropdown list to select values e.g. A1 to A10 have dropdown lists with values "aaaaaa","bbbbb","cccccc","dddddd","eeeee"
There are numeric values from B1 to B10. between 0 to 4
The code or function must read values from column B and select values in Column A accordingly.
If B2 has 2, the value of A2 should be "cccccc" or If B3 has 0, the value of A2 should be "aaaaaa"
Thank You in Advance
Gamini
you may try this.
Thank you, a great job. There is a simple change. Can you please change the function to accept 5 parameters
parameter 1 = Sheet2
parameter 2 = Sheet1
p3 = sheet 2 column
p4 = sheet 1 column
p5= number of cells
The function read numeric values from par 1 and change combo boxes in sheet 1
This is because I have around 1000 combo boxes in one sheet. So this could be a great help.
See attached file
Last edited by gamini; 09-28-2022 at 12:14 AM.
This is not a "simple change" from your description.Originally Posted by gamini
Parameter 1 = Sheet2. What on sheet 2 are we looking at? Your supplied file simply had a range of cells ( 0-5) in column A. Is this how your data is laid out?
Parameter 2 = Sheet1. You indicated in post #3, that Sheet 1 has 1000 combo boxes but you have uploaded the file created by arnelgp as your example. That doesn't help us at all.
Parameters 3 & 4, you reference a sheet number but not a column. Are we to guess the column number?
Have you changed your mind here? Arnelgp has supplied you already with a good answer to this issueThe function read numeric values from par 1 and change combo boxes in sheet 1
Your attached file does not reflect any of this. If you want our help ( and Im sure there are people here who would like to do so), you need to reconsider how you are going about this. Firstly, attach a real file, as in how you have your workbook set out. No, we don't need 1000 comboboxes on sheet1, and no, we don't need your actual data, just something that accurately reflects the type of data.This is because I have around 1000 combo boxes in one sheet. So this could be a great help.
See attached file
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Attached excel file has the real data. In sheet Ranking template has the same combobox in 301*22 cells. In sheet Input you have the numeric values. The function need to read the numeric values in the column"" and select the combobox value in sheet Ranking template accordingly.
e.g. in sheet Input the person "Hon. Aravindh Kumar" has 1 in cell A2 then in sheet Ranking template "Hon. Aravindh Kumar" gets the value "High" (2nd value of the list).
I have such around 120 such work-books.
Sorry if I could't explain in earlier queries.
Thank you all for helping
Gamini
Last edited by Aussiebear; 09-28-2022 at 10:41 PM. Reason: Tidyied up the post
try to input some numbers on "Input" sheet.
As requested I have included more input. Please see attached file sample12.xlsm. Thank you for the patience and trying to help me.
If You need more I will gladly do that.
i added a "Button" on Input sheet for "force" update Ranking Template sheet.
I did a test by adding values to col B toE
colB all 0
colC all 2
colD all 3
colE all 1
Please check new file entries01.xlsm
I clicked the button "Update Ranking Template Worksheet"
But the values in "Ranking Template" didn't change.
Did I do something wrong?
I changed the master Data
5 Very High
4 High
3 Average
2 Low
1 Very Low
0 Unknown
Now for the Row "Hon. Aravindh Kumar" the macro changed all the columns to "Unknown" after clicking the button, but there are no changes to other fields
Please see Entries02.xlsm. There were no warnings. Macros work fine.
Sorry for troubling you..
i import it to sample12.xlsm
Working fine, Thank you so much. Really appreciate it.
Posting Permissions
Reply With Quote
