Hi,

I need some help with the creation of a macro in Excel.

I have in my excel-file created a drop-down list that looks up
different names/codes from a list (in another sheet) and when I select
a name/code a sheet gets populated. After that I push a button that
prints the sheet to a PDF-file (I am using PDF995) where I have to
specify the filename and location. This works well as long as I don’t
need to generate a lot of different PDF’s (then it gets time
consuming).

The thing I would like to do now is to create a macro that prints all
the different sheets that’s gets generated from the different
names/codes that I now need to select and print “manually”.

To further illustrate what I mean:

The list might look like this:
Peter
Fredrik
Jimmy
Jenny
Cecilia

When I in my input-sheet select Peter the sheet I want to print to PDF
gets populated. I want the macro to go through my list from Peter to
Cecilia and generate different PDF-files for each name in the list. I
also would like the files to get saved with the name specified in a
cell in my sheet.

Hope you understand what I mean.

Thanks for any help in advance.


--
dirigenten
------------------------------------------------------------------------
dirigenten's Profile: http://www.excelforum.com/member.php...o&userid=32249
View this thread: http://www.excelforum.com/showthread...hreadid=520010