Test for empty cell in Excell
Posted on 2008-06-15
I have a workbook with multiple worksheets. Each sheet is a detailed page with dates and times. Sheet 1 has been added as a quick view of each page. The rows of Sheet 1, column A has the name of each of the multiple sheets. I need a formula probably in vba code for Sheet 1 Column B and C. Currently the formula is input into each sheet.
For each populated cell in Sheet 1 column A, look at the value in the row of column A (name). Then go to the named sheet and test for the next available empty cell in Column B, read the value from the cell above insert that into the formula below which will be in column B and C on Sheet 1.
The intention is to move columns C and D from the multiple sheets and to just show the equivalent value on Sheet 1 in Columns B and C. See below.
Current - Sheet 'n'
A B C D
1 12/06/08 | 12:15 | =IF(B2="","",(B2+TIME(12,0,0))) | =IF(B2="","",B2+(TIME(20,0,0)))
A B C
1| Name | Next | Local Time
2| sheetn Value of sheetn:Bn Value of sheetn:Dn
I hope this makes sense.