I have list of items in 'Sheet1' - Column A. When I type in 'Sheet2' - Column C, I need that Items in 'Sheet1-Column A' should come as suggestions.
The user will select a item from that. The user is not allowed to type/select items other than in 'Sheet1'. How to do that?