Dynamic counter for counting human blood cell

[fbexel]

Hi to all,

I am trying create an automatic counter for our Complete blood cell count.

I have something in mind using COUNTIF. However, I would like to know if someone have any idea how to manipulate the keyboard function and characteristic to where when a user select and press a letter in the keyboard, the cursor will automatically go to the next cell without pressing the [Enter] button.

If this is doable, then I can easily use COUNTIF to determine how many "K" were entered, and how many "L" were entered, etc. then I can assign K to a particular type of cell.

Curious MedTech.

 

[Cindy Ellis]

Hello and Welcome to the forum!
To the best of my knowledge, there's no way to move to the next (Excel) cell without pressing enter, but you could enter all codes into the same cell, then (for instance) use Text To Columns with a fixed width of 1 to split the values into individual cells.

Hope that helps,

 

[fbexel]

thanks Cindy. I will try the split values.

Curious MedTech

 

[Tinbendr]

You could try something like this.