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?
--

to use the if statement, you need to keep a running list of all meeting dates
and topics. Maybe you can go to 3 sheets, one for current meetings, one for
all meetings, and the other for the list of topics, which would get the
covered date form the all meetings sheet?

"Ruth" wrote:

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?
--

Sorry, this is quite new to me and I don't quite follow you. There will be
more than one topic covered at each meeting. There is about 60 topics that
need to be covered by the end of the year.

Would the the third sheet would it be:

one cell be =Sheet one meeting date
cells next to it = topics

how do I get the values to stay if it is getting the information from the
first worksheet? and what would the formula be in the second worksheet
(topic list)?
--



"dlw" wrote:

to use the if statement, you need to keep a running list of all meeting dates
and topics. Maybe you can go to 3 sheets, one for current meetings, one for
all meetings, and the other for the list of topics, which would get the
covered date form the all meetings sheet?

"Ruth" wrote:

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?
--