Macro for Formatting Spreadsheet

[Ngutierr]

Hello,

I am in need of two Macro's. One that does the following:

1. Automatically delete the contents in Column A, I, and L through T
2. Automatically format A1-J13 with "All Borders"
3. Automatically bold A1-J1.

Please see attached as skeleton for format - NYSE Ticker Format.


The second Macro needs to be as such:

1. Automatically formats column A to Number with 0 decimal places and auto fits to size of cell
2. Automatically auto fit Column B
3. Automatically center E&F.
4. Automatically format G to 267 pixels(Width 37.34).
5. Automatically format H to 301 pixels(Width 42.29).
6. Format Column AC to Number with 0 decimal places
7. Automatically delete Columns J-H
8. Automatically delete I-AB

Any help would be much appreciated! Thank you.