Trevor G
Well-known Member
- Joined
- Jul 17, 2008
- Messages
- 6,717
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
Hi folks,
I have recently taken on some voluntary work for a number of pastoral care teams. I am looking to use VBA to identify if someone hasn't been assigned a care manager.
I have 10 sheets showing Care Teams (1 to 10) - Who the manager is in Cell A1 and the Sheet name is the same, and who is being looked after by that care manager, and 1 sheet which is a download of every person under the voluntary organisation who should be looked after. I am trying to identify who has yet to be assigned a care manager.
I currently do this through inserting columns and then adding the care manager in column B to identify the Team and then create IFERROR and VLOOKUP (10 variables) formula on the download sheet for everyone listed, which is time consuming, as I know I will have to do this for multiple locations I would like VBA to do this.
Column A starting in Cell A3 downwards in each Care Team sheet shows the names of those who have been assigned a care manager . On the download sheet (or create a new sheet) I am looking to identify who hasn't been assigned yet. Column A on the download sheet lists the everyone's names and Column E is where I am identifying who the care manager is or indicating who hasn't been assigned.
Any help is much appreciated.
I have recently taken on some voluntary work for a number of pastoral care teams. I am looking to use VBA to identify if someone hasn't been assigned a care manager.
I have 10 sheets showing Care Teams (1 to 10) - Who the manager is in Cell A1 and the Sheet name is the same, and who is being looked after by that care manager, and 1 sheet which is a download of every person under the voluntary organisation who should be looked after. I am trying to identify who has yet to be assigned a care manager.
I currently do this through inserting columns and then adding the care manager in column B to identify the Team and then create IFERROR and VLOOKUP (10 variables) formula on the download sheet for everyone listed, which is time consuming, as I know I will have to do this for multiple locations I would like VBA to do this.
Column A starting in Cell A3 downwards in each Care Team sheet shows the names of those who have been assigned a care manager . On the download sheet (or create a new sheet) I am looking to identify who hasn't been assigned yet. Column A on the download sheet lists the everyone's names and Column E is where I am identifying who the care manager is or indicating who hasn't been assigned.
Any help is much appreciated.