Computer
New Member
- Joined
- Jan 24, 2019
- Messages
- 9
Subject | Start Date | Start Time | End Date | End Time | All Day Event | Description | Location | Private |
Orient | 1/7/2019 | 8a | 1/7/2019 | 12p | FALSE | Spring Orient. Rm 681 | TRUE | |
LM | 1/7/2019 | 1p | 1/7/2019 | 4p | FALSE | Resume Building rm 681 | TRUE | |
LAB | 1/8/2019 | 1p | 1/8/2019 | 4p | FALSE | Skills Lab | TRUE | |
AH | 1/9/2019 | 8a | 1/9/2019 | 12p | FALSE | Skills Lab | TRUE |
<tbody>
</tbody>
The formula in cell A2 looks like this { =IF(ISTEXT(LEFT(OFFSET('Spring Weekly schedule'!C$6,0,ROW()-2),SEARCH(" ",OFFSET('Spring Weekly schedule'!C$6,0,ROW()-2))-1)),LEFT(OFFSET('Spring Weekly schedule'!C$6,0,ROW()-2),SEARCH(" ",OFFSET('Spring Weekly schedule'!C$6,0,ROW()-2))-1),"") }
Id like to be able to quickly change the row reference for C$6 as there are many cells and Ill do this many times. I was hoping I could do something like C$(B22) and then every time change the number in B22 it auto populates. Is this possible or is there some other reasonable solution?