One of my worksheets is an index of information about foods, and the foods are grouped into categories like fats, dairy, vegetables etc. In order for people to enter new foods in to the index, I have created an area at the top of the worksheet where they can select the category from a drop down box then enter the rest of the information about the food (e.g. energy, protein content etc). Then they should be able to click a button and the information will be placed in the correct position in the index, based on the category they chose.
Initially I wanted to use the find function to copy the name of the category chosen and paste it into the find dialogue, but this can't be done using record macros. I checked how to do it but it seems you need to enable microsoft object forms 2.0 in VBA, but I need a solution that is more simple than this so anyone can use the spreadsheet. I thought perhaps there is another way around it apart from using the find function?
Thanks!
Bookmarks