Hi everyone, hopefully someone can help with this question....

I have a cell, B4, that contains a drop down list of names (from a
validation list), when a name is selected, other selected cells in the
workbook change as they are based on a vlookup. This then changes the 2
charts on the same page.

What I would like to do is allow the user to click a button and spool
thru all the names in the list and print each one automatically.
Can this be done using VBA? If so, how do I go about it ?

Thanks again, lots of love, Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=508886