Hi. I have a 12row x 4column data set on sheet2. I would like to make it so
that the user could type "Event" in a cell on sheet1 and it would
autopopulate with the 12x4 data. This would need to apply to every cell on
sheet1 (or at least the majority of a single column). Is there a way to
accomplish this? The workbook will eventually be shared.
Thanks!