Hi,
I need certain excel formula which will help me to create final project info sheet.
In Sheet 1 in 1st column there will a question or statement & in next columns the options, they may be 2 or many.
Once I place any symbol or content under those options as a selection, I want only that option (answer) with their question or statement to be appear in Sheet 2.
In sheet 2, It will be better if I can edit the question or statement column without effecting the option (answer) column.
This will be "final project info sheet", In which only question or statement & their selected options will be present.
I have attached snapshot for what I want.
I will be thankful for any help.
Bookmarks