Formula Copying
 

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?

Formula Copying
 

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

"qlfl" wrote:

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?