AIDE : créer une FAQ sur Excel
Catherine
-
lillll Posted messages 2 Status Member -
lillll Posted messages 2 Status Member -
Hello everyone,
I have been asked to create a frequently asked questions section in an Excel file
(HTML format is prohibited).
The idea would be to have a question table with the answer in the adjacent column and a "Search" row above. Typing a keyword would filter all the "question - answer" rows containing that keyword.
Do you think it's possible to create this in Excel? If so, could you please give me a little help?
I'm a big novice with Excel ^^
Thank you
Catherine
I have been asked to create a frequently asked questions section in an Excel file
(HTML format is prohibited).
The idea would be to have a question table with the answer in the adjacent column and a "Search" row above. Typing a keyword would filter all the "question - answer" rows containing that keyword.
Do you think it's possible to create this in Excel? If so, could you please give me a little help?
I'm a big novice with Excel ^^
Thank you
Catherine
2 answers
Hello, this seems feasible only with Excel and VBA. First, you need to create a space (or several merged cells) where the search text will be entered. Next to it, there will be a button to validate and start the search. This button will be linked to a VBA code that will initiate the search throughout the FAQ.