Need a macro to format data and delete columns and create new column

Using Excel 2007:

I get an excel sheet with data daily from Column A:L. I need a macro to perform the following on it.

1. Format columns I and K to "Date" as 03/12/13. Current format in columns I & K is date & time.
2. Delete columns B, C, D, F and G.
3. Adjust column A to width 15 and all other columns to fit data.
4. Create a new extra column before existing column A.
5. Put border from A1 to cells under Column G (Number of data in cells varies every day from G1:G100). e.g. data one day may be present from A1:G35, next day may be from A1:G80.
6. Print the sheet in portrait view.

Thanks.

aacod

We would love to help you with your question, but 1st, please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertise, they might only open those threads. also, searching for ""help"" will not turn up too many results that will benefit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

Thanks

Also, I will move this to the VBA forum, you stand a better chance of getting help there