Forum Discussion

MarinaSaadalla's avatar
MarinaSaadalla
Copper Contributor
Mar 07, 2021

Tracking for patients

I'm working on a project. I need to track the patient movements within 14 days if he/she went to same service within 14 days so it will appear with different color as the sheet contains around 16k me...
excel
Yea_So's avatar
Yea_So
Bronze Contributor
May 19, 2021

Hi MarinaSaadalla 

 

I removed the Specific Assessments search box since it seems to make excel crash when left empty, and when both drop downs are empty excel will just stop responding

 

I was looking at the tool and made some improvements on it for example:

If you have a large hit, a card number with a long list

I made a pivot table so when you have something like this you can switch to pivot table view and immediately pinpoint what you need to look at:

when you're doing a search in the search sheet you press ctrl+alt+F5

when you go to the pivot sheet to update the pivot table press ctrl+alt+F5

I'm not sure why it does not update the pivot table when ctrl+alt+F5 should update queries and pivot tables, you would have to inquire with uncle MS about that

 

Also when no card is selected, i set it up to search by default a card number that is

0000-0000-0000-0000

 

you would have to insert that record at the end of the report list in the Patients sheet

like so:

 

Resources