Hi,
I'm running a daily report for my compliance team to flag any missing Right To Work documents in our system for each candidate due to start working for them to review.
I've got this set up to check the status of each item, and then at the end it creates a concatenated list of everything missing, eg;
To try and make it clearer for them and the sales team to read I've set it to add a bullet point icon between each item, however they are requesting that it be formatted as an actual bullet pointed list.
Is there a way to do this with Formula or VBA without going through each row and doing it manually? The list would need to be within a single cell
The size of the list varies and can be anywhere between 1 and 50 items, and I can't just resize the column to make each item move to a new line as it won't line up for every item
I'm running a daily report for my compliance team to flag any missing Right To Work documents in our system for each candidate due to start working for them to review.
I've got this set up to check the status of each item, and then at the end it creates a concatenated list of everything missing, eg;
| [CV]◆[TLD Badge Readings]◆[Signed Deduction Policy]◆[Settled/Pre-Settled] |
To try and make it clearer for them and the sales team to read I've set it to add a bullet point icon between each item, however they are requesting that it be formatted as an actual bullet pointed list.
Is there a way to do this with Formula or VBA without going through each row and doing it manually? The list would need to be within a single cell
The size of the list varies and can be anywhere between 1 and 50 items, and I can't just resize the column to make each item move to a new line as it won't line up for every item
