Are you trying to create a PDF from two worksheets in the same workbook? I don't think this can be done without VBA. If you can attach a sample file, or be very specific about ranges and sheet names, someone could probably give you advice on how to do this with VBA.
-Matt