2 part question
I’m trying my hand at macros for the first time to help out a mate with a spreadsheet.
I’m trying to replicate the process detailed in the link below to generate a search bar with suggested options to search a database of products and build a subset of 6 to print.
http://trumpexcel.com/2013/10/excel-...h-suggestions/
I must have done something wrong along the way as I can’t seem to get the drop-down component to work. Note: the 3 helper columns (described in the linked article) can be found under the entry number heading (where they will be hidden by formatting in the final version).
My second issue is that when an item has been searched I want to generate a macro linked to the ‘Add Button’ to copy that name and paste it into the next blank cell in the range $I$13:$I$18.
Any help with either of these issues would be greatly appreciated.
Regards
MattRNR
Bookmarks