M
monkeyhop
Problem:
I have 4 worksheets in the same workbook: sheet1 sheet2 sheet3 sheet4
I want to get cell B10 of sheet4 to get info from cells B5 of sheets
1,2, & 3
BUT: Only one of those 3 cells will have something in it to print to
B10,
Else if none of those cells has anything then leave it blank in B10
The cells are formatted in Time: 5:00 pm and such
I've been trying to get a formula to work trying different methods and
I get these results: #value, 12:00 am, etc
I can get it to print any cell that has something but if none of those
cells has anything it prints #value, 12:00 am
Thanks in advance,
monkeyhop
I have 4 worksheets in the same workbook: sheet1 sheet2 sheet3 sheet4
I want to get cell B10 of sheet4 to get info from cells B5 of sheets
1,2, & 3
BUT: Only one of those 3 cells will have something in it to print to
B10,
Else if none of those cells has anything then leave it blank in B10
The cells are formatted in Time: 5:00 pm and such
I've been trying to get a formula to work trying different methods and
I get these results: #value, 12:00 am, etc
I can get it to print any cell that has something but if none of those
cells has anything it prints #value, 12:00 am
Thanks in advance,
monkeyhop