Is there someway that I can have a row of cells prefilled once the first cell is filled? For example, I have a spreadsheet where column A & B are optional, but once B is filled in, I would like C, D, & E to automatically fill in for each row. The data in C, D, & E depends on the data in B. B will contain names. C, D, & E contains data related to that name that will always be the same. Anyone know if this is possible?