changing cell value from a drop down list

Question

Hi All&nbsp;I'm in need of some help.&nbsp;I have two tabs, one for DATA and one for SEARCH.&nbsp; I would like to be able to use a dropdown menu in SEARCH to update a cell value in DATA.&nbsp;Search Tab&nbsp;&nbsp;Data Tab&nbsp;&nbsp;When a serial number is entered in cell D2 Search Tab, it then populates the make, model and status using index and match.&nbsp;What i'm looking to do is to select Faulty from the drop down menu in the Search tab and then it updates the Data Tab with that new value.&nbsp;Is this possible?TksAB

sergeibaklan · Answer

AB747F&nbsp;
I guess that's not the only record in Data tab with the same Status. If you select some Status in Search tab, would you like to show here all records with selected Status, or there are other criteria to select only one?
And on which Excel version/platform you are?

ab747f · Answer

Thanks SergeiEssentially i would search for the serial number in the Search Tab. This would then populate the records ie make, model, serial number and status.If i selected Faulty in the dropdown based on the serial number, i would like that to change the data in the data tab (in this example Data Tab D2 to Faulty).Is this possible? I'm using version 2304 16327.20324ThanksAB

sergeibaklan · Answer

AB747F&nbsp;
Afraid that's with VBA programming only. Perhaps someone else could help, not my territory.&nbsp;
HansVogelaar&nbsp;?

ab747f · Answer

Thanks SergeiI thought that maybe the case. Is there any way around this? Would the following be possible?If Cell G2 was manually entered instead of a drop down, would this be able to update D8 in Search and D2 in data? Or am i still looking at VBA?TksAB

hansvogelaar · Answer

AB747F&nbsp;
You'll need VBA. See the attached demo workbook.
You'll have to allow macros when you open it.
To inspect and modify the code, right-click the sheet tab of the Search sheet and select 'View Code' from the context menu.

Forum Discussion

changing cell value from a drop down list

5 Replies

Resources