Working with for, next

[Len Silva]

I have a sheet in my workbook (attached) with a bunch of VLOOKUPs based on the unit number in cell F1. The data comes from a sheet called Master.
Master has a named range UNIT (A3-A86).
What I am trying to do is a loop to populate F1 with the first value in range UNIT, print the sheet, then return and get the next value and repeat the process.
I think a for-next loop is what I need but i"m not sure.
Thanks in advance for any help.

[TMS]

Try

Please Login or Register  to view this content.

[Len Silva]

You make it so simple. Thanks so much.

[TMS]

You're welcome. Thanks for the rep.


Now it's easy, once it wasn't