Forum Discussion
Ewout124
Jan 04, 2022Copper Contributor
Creating a list of terms, concepts, etc.
Hi all, I don’t know if I have come to the right place for asking this question, but I will give it a try. I want to create a sheet for collecting all kinds of terms, concepts, abbreviations, etc...
JKPieterse
Jan 04, 2022Silver Contributor
Best to start with a simple table containing the columns you have in mind, one column for every type of information you want to store. Use a single row of cells to name each header and convert that range to a table (Insert tab, Table button). For new terms you simply type them into the term column. Later, when you're ready to add more information you can filter the table for empty columns so you know where new data needs to be entered. If you set up a conditional format on the keyword column to highlight duplicates, anything you enter that already exists will highlight.
Ewout124
Jan 04, 2022Copper Contributor
Thank you for your reply, Jan Karel. By now, I have managed to create a sheet that (so far) seems to work reasonably well. I have used the VLOOKUP function to check for the existence of a term, and I have a recorded a macro to copy a new term into the table containing the existing terms. I have to find how the sheet behaves in real life, but so far it seems promising!