create a call until end of data

I have a sequence of subs that I call to sort and carry out calculations on a set of automatically collected data. I then need to execute the same sub to rearrange a single column into 2 and delete now unneeded rows.

I have assigned a key pres to this and keep pressing until I reach the end. How can I automate this?

I’m looking for something like

While Not End Of Data
call mysub
wend