Integrate Excel into Outlook

[MarketingAnalyst]

I have beyond boggled my mind trying to make my job a bit simpler or less time consuming. I have spent about an hour but have not found an answer yet, so I am not sure if this is possible at all.

This is what I have::
I have multiple worksheets of brand analysis statistics. I download about 300 of these a day, each worksheet has multiple equations, I need one total at the end (same cell on every worksheet) to be placed into a calendar(I was hoping outlook so I could sync it with my blackberry) with the name of the worksheet or document and the total of that cell on the correct day. Is it possible?

I am hoping the first option will work, but if not, will this second option work outside of my head? If I make 1 workbook with all the worksheets per day (I am not sure how many I can have) copied into a template then make a workbook of January-December calendars, can I somehow link all the different cells I need in a calendar in a different file, maybe referencing between files?

Any help would be greatly appreciated!
Nikki

[mrice]

Sounds possible. Some questions...

Where are the 300 workbooks - are they in the same folder? Are there new ones every day or it it the same ones updated. What would the Outlook item be - a mail message or something else?

[Kyle123]

I do something similar, try the below, you might need to adapt it a bit to meet your needs, but if you've got any questions please ask.

I've set the url to one you will be able to download (thanks Jerry )

Please Login or Register  to view this content.

[MarketingAnalyst]

mrice~the 313 are all in one folder. The files are new everyday. I would like the final total to be located on the calendar.

Kyle123, thank you I will check this out after dinner

Thank you very much for both of your responses.

Nikki