Forum Discussion
changing cell value from a drop down list
Hi All I'm in need of some help. I have two tabs, one for DATA and one for SEARCH. I would like to be able to use a dropdown menu in SEARCH to update a cell value in DATA. Search Tab ...
Thanks Sergei
Essentially 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.20324
Thanks
AB
Essentially 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.20324
Thanks
AB
Afraid that's with VBA programming only. Perhaps someone else could help, not my territory.
- Thanks Sergei
I 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?
Tks
ABYou'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.
