I have a worksheet with dates in the first column and header rows are jobs to do. Each row has initials of people set to do those jobs. There may be more than one job per person - shown as that persons initial being in more than one column in any particular row.
The sheet is not easy to read for an individual person. I’d like a formula to create an individualised sheet for each person showing their jobs each day.
The worksheet would probably start with dates down the initial column - then a lookup formula pointing to the original worksheet and the row of the corresponding date. It would then look for cells with that persons initials in, and show the corresponding header row to that cell. It would need to cope with there potentially being several or no instances of the initials in any row.
The sheet is not easy to read for an individual person. I’d like a formula to create an individualised sheet for each person showing their jobs each day.
The worksheet would probably start with dates down the initial column - then a lookup formula pointing to the original worksheet and the row of the corresponding date. It would then look for cells with that persons initials in, and show the corresponding header row to that cell. It would need to cope with there potentially being several or no instances of the initials in any row.