I'm trying to do an absolute cell reference but the reference is on another
"tab" or sheet. Same file just different file. I only want the column to
change but to fill the row down.
Formula using:
=Period1!E$5/Period1!E$4

Period1 is the sheet on the same file

and I want to fill down...not over

so switch columns not row...and fill down! Thanks All.

Its for a grade sheet for my teaching. Thanks