I require a macro that will save as a PDF the headings on Row 1 and the information on the Row that is attached to the macro. A macro button would be placed on each row below the Heading Row 1.
The maximum length of the information is to Column M.
The PDFs are to be saved to the same folder that contains the spreadsheet with the information.
The name of the PDF would be derived from the information in Column B and Column A with an underscore between the two.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
For example:
The Headings are on Row 1 (Always).
The Information is on Row 3.
<o> </o>
Row 1 (Headings)
Name Number Date Amount Tax Comment
<o> </o>
Row 3 (Information)
ABC Company 123456 02/28/2011 $100.00 $13.00 Plastic Bags
<o> </o>
The PDF in this case would be:
123456_ABC Company.pdf
<o> </o>
PDF:
Name Number Date Amount Tax Comment
ABC Company 123456 02/28/2011 $100.00 $13.00 Plastic Bags
<o> </o>
<o> </o>
Thank you for your help,
<o> </o>
Hydro Man
The maximum length of the information is to Column M.
The PDFs are to be saved to the same folder that contains the spreadsheet with the information.
The name of the PDF would be derived from the information in Column B and Column A with an underscore between the two.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>For example:
The Headings are on Row 1 (Always).
The Information is on Row 3.
<o
> </o>Row 1 (Headings)
Name Number Date Amount Tax Comment
<o
> </o>Row 3 (Information)
ABC Company 123456 02/28/2011 $100.00 $13.00 Plastic Bags
<o
> </o>The PDF in this case would be:
123456_ABC Company.pdf
<o
> </o>PDF:
Name Number Date Amount Tax Comment
ABC Company 123456 02/28/2011 $100.00 $13.00 Plastic Bags
<o
> </o><o
> </o>Thank you for your help,
<o
> </o>Hydro Man
