Hello helpful people! Here is my dilemma. I have a workbook that has a summary {Summary} page and ten worksheets {Employer #1, Employer #2, etc.} with specific data. Based on a Yes/No answer on the Employer sheets, I need data from two specific cells {B11 and F16} to transfer to a specific cell {B10} in the Summary sheet. That is the first part.
Second part is if there is a No answer on multiple Employer sheets, the exported data must go into the same cell {B10} on the Summary sheet. For example:
Based on the above information that would be on the Employer sheets, the output on the Summary sheet in cell B10 would be "160852 Data not scanned. 138952 Shortage letter not sent."
I am looking for a formula instead of a macro on this one. It needs to be automatic, not on demand. Any help is appreciated!
Second part is if there is a No answer on multiple Employer sheets, the exported data must go into the same cell {B10} on the Summary sheet. For example:
| Sheet | B11 | F16 |
| Employer #1 | 160852 | Data not scanned. |
| Employer #2 | 138952 | Shortage letter not sent. |
Based on the above information that would be on the Employer sheets, the output on the Summary sheet in cell B10 would be "160852 Data not scanned. 138952 Shortage letter not sent."
I am looking for a formula instead of a macro on this one. It needs to be automatic, not on demand. Any help is appreciated!
