Macro to format all worksheets and then print workbook

Hi all,

I receive a workbook every day that has approximately 30 worksheets in it. Each worksheet has the same columns headings in A through K. Column A lists an account number, and the remaining columns contain additional information about the account.

On some days, a worksheet may simply contain one or two account numbers. On other days, there may be 30 or 40 rows of data.

I want to create a macro that I can store in my personal workbook that will autofit columns and resize the print area for each worksheet to one page. Basically, I want to print each worksheet onto one piece of paper - if there are more rows of data, the font can be reduced so everything will fit on one page. I then want the macro to print each worksheet within the workbook.

Can anyone advise on how I might create this macro?

For each worksheet in the workbook:

1. Autofit columns
2. Set print area to one page
3. Print worksheet

Any suggestions/advice are greatly appreciated. Thanks for reading.

-Student1990

I would suggest recording a macro to set-up the format you want for one page. Then we can easily help to modify it for the entire workbook.

Hi John,

I recorded a sample of what I'd like to do to each worksheet in the workbook. Is there a way to modify this so it will apply to every single worksheet in the workbook? Thanks for your help!

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.