macro to generate SRV slip Till last no.

Hi,
I am facing problem to put each time SRV no. in "H6" to generate SRV slip and print out.
I don't know how to put some code in the existing macro so that it can automatically generate the SRV of till the last SRV found in data register sheet. Suppose i enter in cell "H6" 1125 and click on button then it only generates single SRV but what i want is it generate SRV from No. 1125 to 1145 as 1145 is last SRV no. in "Data Register sheet". But all SRVs should be saved underneath previous one in same sheet.

Thanks in advance.