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

Sorry...Period1 is another sheet on the sane file

"DJ Harrington" wrote:

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

sorry Period 1 is another sheet on the same file
Same file just different sheet

"DJ Harrington" wrote:

Sorry...Period1 is another sheet on the sane file

"DJ Harrington" wrote:

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

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

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

I have the file. Please tell me where to find the formula and what is to be
done (let's be sure we are on the same wave length)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

P1 Student Summary
On HW/Test/Quiz = A19
and B19 , C19, D19, E19
"Bernard Liengme" wrote:

I have the file. Please tell me where to find the formula and what is to be
done (let's be sure we are on the same wave length)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

I'm sorry I didn't read the whole thing...

On "Period 1" she I want to put the scores and such.

On P1 Student Summary, I want I want A19 to be filled down to like A30
but on the "period1" sheet..I want A19:A30 (P1 Student Summary) to represent
E2:O2 (Period1). Pretty much the same thing for B19..the codes are there but
they just won't fill down, they will only fill across. Thanks sorry for the
late response!

so on Period1 you have this for E5:I5

12 24 25 12 15

on P1 Student summery I want C19:C23 to represent that..but don't want to
hand put all the information.

so for P1 Student summary it should be for C19:C23

P/Given
12
24
25
12
15


Thanks
"DJ Harrington" wrote:

P1 Student Summary
On HW/Test/Quiz = A19
and B19 , C19, D19, E19
"Bernard Liengme" wrote:

I have the file. Please tell me where to find the formula and what is to be
done (let's be sure we are on the same wave length)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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