Doesn't work..Heres the link to the file!
<href="http://www.quickfilepost.com/download.do?get=1d0737cb55d2aeafa66708e80bfbdbbe" My File</a
http://www.quickfilepost.com/downloa...6708e80bfbdbbe

P1 Student Summary is the table
Assignment's should fill down not over
Just like HW/CW...

Thanks

"Bernard Liengme" wrote:

But it IS working! Let's say you enter that formula on Sheet1 in A1. The
reference is to a cell on another worksheet in a cell that is 4 columns to
the right of the cell where the formula is (E is four over from A). Now you
drag the formula down to A2, So we want to refer to a column that is 4 to
the right but that is still column E

Try this. Enter the formula in A1, drag to the right as far as needed.
Select B1 to the end and Copy
Click on A2, use Edit | Paste Special with Transpose selected. Now you have
the formula you want in a column and can delete those in the top row

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DJ Harrington" <DJ wrote in message
...
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