you could use a vlookup say to lookup there name on the list and show that on
your first page,and then repeat witha macro....the exact macro cose will
depend on how your data is arranged on the other sheets,one athlete per sheet
.....or several per sheet or many per sheet??
--
paul
remove nospam for email addy!



"Strength and Conditioning Programs" wrote:

> I was wondering what steps would I need to take to create workout sheets for
> my athletes. I have the program, exercises, and formulas I need to run the
> program, but here is the problem. I don't want to individually insert their
> name, max information - print the sheet, and repeat for the next athlete.
> That information is already on another another list. Is it possible to run
> some type of merge where the program automatically goes to the next person on
> the list and their information?