VBA Question

[Rcboyd123]

Hello,
I have an excel spreadsheet which is basically a message log. We are a paperless company so I made a spreadsheet which has an input page and 5 other pages - Monday - Friday. The input page asks for the Caller Name, Number and Details, it sends the info to the corresponding day page. On the "Day" worksheet there is a column labeled "Returned" where I will just put in Yes if I have returned the call, or leave it blank if it hasn't been returned.

I would like to display on the input page whether or not there is unreturned messages, but I am not sure how to do that, what code or search function.
Please help!!!

 

[Eric W]

It really depends on how your sheets are organized, and how the Input sheet sends the data to the day sheets. Let's say your Monday sheet has column A for Caller Name, and Column D is the Returned column. Then you could try this formula on your Input sheet:

=COUNTA(Monday!A:A)-COUNTA(Monday!D:D)

COUNTA counts how many cells have data in them. The first COUNTA finds out how many calls you have, and the second finds out how many have been returned. The difference is the number of calls you need to return. We could use INDIRECT to make a formula for all sheets, but with only 5 sheets, it's easier just to manually enter them.

If the day sheets have formulas, this won't work, but there are other options.