If Function on calendar, expense report.

P

Paula

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top