if function
I have two worksheets, one has meeting date and topics covered.
The second sheet has all the topics that have to be covered by the end of
the year.
I used an if function to fill in the date that the topic is covered on the
second worksheet using the date on the first worksheet.
However when the first worksheet is used again with a new meeting date and
topics the date disappears on the second sheet and is updated accordingly.
I want the dates to stay in the second worksheet once a topic is covered, so
that at the end of the year, you can look at the second worksheet and tell
the date each topic was covered.
How is this done?
--
:)
|