I want to fill a range of cells let's say A1:A5 with the value that is in a drop down list let's say in B1, by clicking once with the mouse in cells A1:A5. The way i want it to work is to first select the value that i want from the dropdown list and then click in in any of the cells from range A1:A5, and only the cell selected changes to the value from the dropdown list. And also when i change the value from the dropdown list the cells that were previously filled by clicking them do not change automatically to the new value from drop down. Once clicked they remain to that value until clicked to another selected value.(Ex:i select from dropdown B1 cell value 1, and then i click cell A1, and this cell is filled with 1, then i select from dropdown value 2, and the i click cell A2 which is filled with 2.The cell A1 previously filled remains the same (1), and the other cells from the range that were not clicked do not show anything).
Bookmarks