loop continue till last invoice (srv) no. in specific column.

[amarjeet.it]

hi everyone.

Here I have a macro on the "SRV Format" sheet which generates SRV (Invoice) slip from "Data Register sheet" (Raw Data) one by one. Every time i have to put SRV no. in "H6" cell then click on "Get Data" button then Copy the srv and paste it to "Result" Sheet. It's a lot of work to do. and i know process can be less by vba that is why i am posting it here.

what i want is when i enter a srv no. 1125 in H6 cell and click on button then macro also generates all the other srv like 1126,1127,1128... one by one and save it to "result" respected format. for Example you can see my attachement and "Result".



Thanks in advance....