Apr 24 2022 04:45 AM - edited Apr 24 2022 04:46 AM
Hi Every One
I have table A and Table B with me.
Table B is master list of items with prices.
In Table A I need to put input item name, for that it will be difficult to enter full name every time from Table B.
So that I need to use a data validation trick to enter the data.
What I need is, whenever we enter first letter, in searchable area, suggested list of items from Table should appear. The Data entry man can choose the item to proceed.
Is there any VBA of formula for this????
Apr 24 2022 07:46 AM
Are you looking for something like this? This feature is currently available to Office insiders Beta channel.
Apr 24 2022 09:33 PM
Apr 24 2022 09:35 PM
Apr 24 2022 10:45 PM
Apr 28 2022 01:57 AM