Hi Exceltip,
First of all, my problem is not related solely to Excel.
I maintain a book borrowing tracker in an excel file. I need to email the book usage summary everyday. Now, I need a Macro code (VBA or Excel Function Combinations) to generate the summary to another sheet.
Basically, the summary table and the tracker table has the same columns and formats. From the tracker table, the summary table would display books only borrowed today (e.g. Sept-10) or borrowed date earlier than today, or loaned, (e.g. Sept-1) that is not yet returned or returned today (Sept-10). Summary table will not display books that are borrowed and returned earlier than today (e.g. Borrowed: Sept-9, Returned: Sept:-9).
I will attach a sample file to clarify my inquiry.
Next, if someone knows how to do it, I would like some help to make a template message for Outlook (a VBA Coded Message) so that whenever I open the template, it will get data from the summary table and will be ready for mailing.
I know the last part is out of scope or maybe impossible but if we can find solution to it, I know it will greatly help, not only me, but also to other Microsoft Office users who sends reports daily.
Cheers,
Bookmarks