Creating a Macros or VBA to auto sort data by three columns

[SMITH.CRYSTAL]

I have a spreadsheet that I would like to create a macros for. I have never used VBA but if you can walk me through it that I'm sure I can get it done. I receive a file and I have to do the following to it:
Font changed to 12
Row Height changed to 45
Custom Sort by Street Name, Number, and Pole Number
Add Header by Document Name
Add Footer Page # of ?

I receive about 75 emails with these files in them over the course of a week which is why I'd like to simplify my process for each one.

I can set a macros for all except the custom sort. Can someone help me figure out how to add the sort or write a VBA to include all of this?

Thanks,

[Leith Ross]

Hello SMITH.CRYSTAL,

Your description of the problem is too general to provide you with specific answers. You will need to post a workbook with before and after examples.

Please change or redact any private, confidential, or sensitive information prior to posting.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[SMITH.CRYSTAL]

I changed all information but the formats and column headers are all the same. I need a macros/VBA to go from Original to Final. Thanks.

[Leith Ross]

Hello SMITH.CRYSTAL,

The attached workbook has the macro below added to it. The macro name is Reformat. This format the worksheet, sort it using the 3 columns you mentioned, and adds the header and footer.

Macro code...

Please Login or Register  to view this content.

[SMITH.CRYSTAL]

Thanks! That works perfect.

[Leith Ross]

Hello SMITH.CRYSTAL,

You're welcome.

To add a shortcut key...

1. Open the workbook in Excel.
2. Press ALT+F8 to open the Macro Dialog Box.
3. Reformat should be highlighted in the list. If not then left click on the macro's name.
4. Left Click on the Options... button or press ALT+O..
5. The cursor will be blinking in an empty box with CTRL+ next to it. This is for the shortcut key.
6. Type in any character, number, or letter you want to use for the shortcut key.
7. You can add a short description of what the macro does in the box labeled Description:
8. Click OK