Hello - I'm trying to create a sentence in a cell based on the values in other cells in a different worksheet. On one worksheet is the picture below where the entries are made and i can put in yes or no.
Based on the entries to theses cells, I want to create a sentence below on a separate worksheet:
NOTES: Vacation, Sick, Medical, Reporting, and Mercury will be billed as incurred.
If the user has a no in the cell, than that word will not be in the sentence. The user can only select yes or no and all the yes answers will show the cell above in the sentence with a , separating the words.
Based on the entries to theses cells, I want to create a sentence below on a separate worksheet:
NOTES: Vacation, Sick, Medical, Reporting, and Mercury will be billed as incurred.
If the user has a no in the cell, than that word will not be in the sentence. The user can only select yes or no and all the yes answers will show the cell above in the sentence with a , separating the words.