J
John
Hello.
I have two sheets in a workbook. One is a Summary sheet, and the next is
titled "Bldg 5".
What I am trying to make sure is that the range A1:K20 on the Bldg 5 sheet
has had data entered to them (ie, they are not blank).
The question that corresponds to Summary sheet A1 is "Has the data for Bldg
5 been updated?"
If ANY blank in Bldg 5's range A1: K20, then put a "NO" in Summary A1's
cell. If ALL of the Bldg 5 range had data in it, then put a "YES" in Summary
A1.
I also need A1 to update as data is entered into the Bldg 5 range
(automatically refresh) so it does not erroneously show a NO when all data
has indeed been entered.
I know that this is some combination of an IF statement, but something else
has to happen to make sure that it updates as data is entered on the other
sheet.
Appreciate any help or starting path.
VR/
John
I have two sheets in a workbook. One is a Summary sheet, and the next is
titled "Bldg 5".
What I am trying to make sure is that the range A1:K20 on the Bldg 5 sheet
has had data entered to them (ie, they are not blank).
The question that corresponds to Summary sheet A1 is "Has the data for Bldg
5 been updated?"
If ANY blank in Bldg 5's range A1: K20, then put a "NO" in Summary A1's
cell. If ALL of the Bldg 5 range had data in it, then put a "YES" in Summary
A1.
I also need A1 to update as data is entered into the Bldg 5 range
(automatically refresh) so it does not erroneously show a NO when all data
has indeed been entered.
I know that this is some combination of an IF statement, but something else
has to happen to make sure that it updates as data is entered on the other
sheet.
Appreciate any help or starting path.
VR/
John