Hi everyone,
I am learning about macros and would like to include them in my work. I need some help with a project. I have a file already, but it is too big to post. I am willing to email it to anyone who wants to help me.

I am working on am excel file that analyzes index prices. It monitors personal aspects I designed as triggers to make decisions on buying and selling funds.

I would like to be able to open the excel and have itself update itself. I have a solution now, but it take daily action on my part. If I didn't do it for few days it would be nice if it did it itself.

I am looking to append the closing prices of the funds to my already established chart at the bottom. I used DATA>FromWeb to get the last two days of data.(I used the last two days in an early attempt for my project) It would be nice to be able to use DATA>FromWeb, get 20 to 30 days of data, and then let the macro decide when the last update was and where it needs to begin its append operation.

I would appreciate any help on this and am willing to answer question to clear anything confusing up. My current solution comes from a modified version of this thread "http://www.excelforum.com/excel-programming/754483-macro-to-append-data.html"

Hopefully I can get some help soon.

Thanks guys and gals,
Josh