Need help fixing a macro

So I have a couple of excel sheets

1) CHEYNEAMHY (no macros, just information)
2) Portfolio_Analytics AHY 3-2-08.xlsm
3) Portfolio_Analytics AHY 3-2-08.xls

NOTE 1: macro is in the xls file, but it NEEDS to be in the xlsm file because it has extra features, so this has to be done in excel 2007
NOTE 2: When opening the portfolio sheet you will encounter some errors since it cannot pull some data from some databases since you arent here)

First try this, open Portfolio Analytics...go to the output sheet..hit calculate a few times...you will see the numbers populate...

NOW...

What I need the macro to do is this (FROM THE Portfolio sheet):
1) Delete all the data from the Input sheet in Portfolio Analytics (cell ranges vary every day so maybe it should delete upto row 1000, but columns stay constant from A-AA)
2) Open the CHEYNEAMHY sheet
3) In the CHEYNEAHMY sheet - sort by desc. and then by maturity
4) Copy the data in CHEYNEAMHY and paste it into the Input sheet in Analytics
5) Wait five seconds
6) Run the calculate as mentioned above...with 5 second intervals in between
7) Save the file with a seperate name (Portfolio_analytics_todays_date) (so when I run the macro it always saves it with a new date)
8) Print the file

It would be great to have a button on the output page that says "PRINT" that when i click it runs the macro

I have already done a lot of this (as attached) but it just doesnt seem to work like I would like!

Any help would be appreciated, thanks
Start Free Trial