Forum Discussion
DerekB192
Jan 05, 2023Copper Contributor
Fill suggestions
I have one workbook. 2 sheets. Sheet 1 has inventory items in column A and the price for each item in column B. On sheet 2 I have items in column C. Right now items has a dropdown that references column A on sheet one. What I would like to do is just start typing an item into a cell and have it suggest the closest match from column A on sheet one, instead of having to scroll through a dropdown.
If you have Microsoft 365, this feature will be added some time in the not-too-far future (it's not known when exactly).