Absolute Reference from another Worksheet

[michaelg1]

How do I use an absolute reference when linking data from a different worksheet? For example when I enter =+'Electric 2018'!$C7/'Use per Tenant'!C$15 it doesn't work.

 

[michaelg1]

I enter +cell c7 from worksheet Electric 2018 and / by cell c15 on worksheet Use per Tenant. I then put $ in front of c in $c7 and in front of 15 in c$15. And I drag across. However only C$15 remains absolute but $c7 does not. It actually makes the whole c7 absolute.

 

[Joe4]

And I drag across. However only C$15 remains absolute but $c7 does not.

It is actually working as expected. Think about it. When you are dragging across, you are just changing the column, not the row. So only the relative (unlocked) column references will change when you drag across.
Likewise, only the relative (unlocked) row references change when you drag a formula down.

To see a real example, add a simple relative reference (nothing locked) like this:
=C7
across and see what happens.
Then drag it down and see what happens.

 

[michaelg1]

I see. The issue is that the data I want from the first sheet is going down changing rows. However on sheet 2 when I am dragging the formula I am dragging across changing columns. What formula can I enter to accomplish this?

 

[Joe4]

You can probably use the OFFSET function to do what you want, allow with using ROW() and COLUMN() to return the current row/column references.
For example, let say that in cell A1 on Sheet1, you want to return the value form A1 on Sheet2.
However, as you drag that formula across, you want to return the value from A2 on Sheet2 in cell B1 (instead of B1).
Then you could use a formula like this:

=OFFSET(Sheet2!$A$1,COLUMN()-1,0)

and drag across.

See here for more details/examples on OFFSET: https://exceljet.net/excel-functions/excel-offset-function