Hi,
Don't know if the following is possible, but will ask the question.
I have a workbook that conatains two sheets. The first 'book1' is a results page and contains a few vlookup formulas.
My second page contains my raw data.
The workbook is to monitor training requirements and when I select a name from a dropdown in 'book1' it populates various fields within the sheet from 'book2'.
I would like to have a button or a drop-down function that enabled me to generate a list of employees who-
1. still require a particular type of training and/or
2. traing that is due to expire within 3 months
The data 'book2' is set up as follows -
the first column contains the names the rest of the columns either contain dates training was completed or blank. Each of the columns has a header naming type of training. There are six columns to extract data from.
I would like to generate a sheet that has six columns of names and the row header would be type of training.
Thank you.
Don't know if the following is possible, but will ask the question.
I have a workbook that conatains two sheets. The first 'book1' is a results page and contains a few vlookup formulas.
My second page contains my raw data.
The workbook is to monitor training requirements and when I select a name from a dropdown in 'book1' it populates various fields within the sheet from 'book2'.
I would like to have a button or a drop-down function that enabled me to generate a list of employees who-
1. still require a particular type of training and/or
2. traing that is due to expire within 3 months
The data 'book2' is set up as follows -
the first column contains the names the rest of the columns either contain dates training was completed or blank. Each of the columns has a header naming type of training. There are six columns to extract data from.
I would like to generate a sheet that has six columns of names and the row header would be type of training.
Thank you.