Refrence next blank cell to repeat VBA Code

[SirAustin1]

Hi All,
First go here so i hope someone can help me out. I have recorded a macro that copies the date and other selected data on the attached spread sheet to create a history of my Count and Purchase Colums, but what i need the macro to do now is have it repeat for every time i do a new count, so it selects the next blank cell in Row 10 and pastes the new count and purchase that i do there thus creating a history.
Hoping some one can help me out


Cheers,
Austin