Formula Copying

[qlfl]

I am trying to copy a formula down a column. It references cells in another
tab of the worksheet.

For example: ='Only Change This Sheet'!B$2+'Only Change This
Sheet'!B$6+'Only Change This Sheet'!B$11+'Only Change This Sheet'!B$20+'Only
Change This Sheet'!B$27

I want the next cell below this one to Change to: ='Only Change This
Sheet'!C$2+'Only Change This Sheet'!C$6+'Only Change This Sheet'!C$11+'Only
Change This Sheet'!C$20+'Only Change This Sheet'!C$27


The column labels do not change. I entered $ so it would not change the
row. But when copying and pasting it copys the example, and does not change
the column. If I remove the $ sign it changes the row number.

What am I doing wrong?

 

[Eduardo]

Hi,
if you copy down, it will not change the column, you will get the results
you are looking for if you copy formula to the first cell to your left