Repeat a Name starting in Jan thru Dec.

Brass Contributor

I would like a person name to end up in the same cells for each of the 12 months. Is this possible?

1 Reply

@wjallen14   the easiest way is to select all 12 tabs and then type that name into the cell you want and it will be placed into that same cell location on all 12 tabs.

if you want to be able to update 1 sheet (i.e. Jan) and have it update on each of the others I recommend

  1. type name in Jan
  2. highlight Feb - Dec and select correct cell location
  3. type =
  4. click on Jan and select cell and hit Enter