Hi, I am new to this forum
I would like to ask if you could help me with my problem. I am currently creating a progress monitoring report and I have data which looks like this:
On sheet 1 Column A, let's say I have the name of my staff
On sheet 2, I have a dropdown cell for Staff and a dropdown cell for Report.
What want to do is when, for example I chose Staff AAA, I will only see all the Reports of staff AAA to the Report Dropdown.
Thank you for your time
I would like to ask if you could help me with my problem. I am currently creating a progress monitoring report and I have data which looks like this:
On sheet 1 Column A, let's say I have the name of my staff
| Staff | Report |
| AAA | Report 1 |
| AVM | Report 2 |
| AAA | Report 3 |
| RGR | Report 4 |
| AVM | Report 5 |
| AVM | Report 6 |
On sheet 2, I have a dropdown cell for Staff and a dropdown cell for Report.
What want to do is when, for example I chose Staff AAA, I will only see all the Reports of staff AAA to the Report Dropdown.
| Staff | <Dropdown list> |
| Report | <Dropdown list> |
Thank you for your time
