I am trying to build a calendar and expense report in a workbook for 105 of
our consultants. This is what I need next: On Calendar is question, do you
have expenses related to this trip?. I know the formlula that will enter the
date on the expense report if answered yes. But that is too limited. What I
need is a formula or macro for the expense report, so if calendar says "Yes"
I have expenses, then rest of the information, such as mileage and purpose of
trip, will be transferred to expense report as enetered into calendar for
that person. Each consultant has their own calendar and expense report.
Please advise. Thanks!