Basically I have 2 sheets, "invoice" and "data".

I'm pulling data out of the data sheet and populating fields in the invoice.
I've been using vlookup to pull the data from the "data" sheet, populate the
invoice using the vlookup, do stuff with the invoice sheet (which i've built
a macro for already), and then I'd manually increase the target value by one
to go onto the next row.

I need a macro that will loop by adding +1 to the target value in my vlookup
formula and keep looping until there are no rows left.

Alternatively it'd be useful if a dialogue box would let the user tell the
macro where to start and end with the loop...if that's feasible.

any suggestions?