Forum Discussion
Program tracking
Hello, I’m not sure what the best option would be best to meet my needs on a patient tracker excel spreadsheet. Each column has name, ID number, date referred, date evaluated and other info. In t...
The Worksheet_change event in the "Database" sheet in the attached sample file copies a row to the designated sheet if either "AS" or "XY" is entered in a cell in range E2:E26. This could be similar to what you are looking for if i correctly understand what you want to do.
If you work with a recent version of Excel you can alternatively apply the FILTER function.