Keeping the column and increment the rows

[akhlaq768]

How do I write the code so when i highlight the field with the formula and drag it accoss the cells, the link to column A stays the same and the rows increment by one....

=Sheet1!A3

I'm sure i have to place a dollar sign somewhere but I dont know how, i've tried all the variable possible...

[antoka05]

If you use that formula in more rows but always in the same column you don't need to use dollar but if you want to refer to column 'A' when you copy formula in more columns you need to put '$' before column 'A'.

In other words, '$' before column lock column, before row lock row number.

For example if you put this formula in range 'c1' and copy it to range 'd1,'e1',ecc. you need only to lock column:
=Sheet1!$A3

Regards,
Antonio

[akhlaq768]

thanks for that... unfortunately i want to drag the selected field across (A1:Z1)... it does change the number!!!

[akhlaq768]

please see attached, ive tried what you have suggested... but it doesn't work



See Sheet4, cell C3 to AF3

[antoka05]

I'm sorry to answer so late.

I think the right formula to put in range 'C5' of sheet 'Sheet4' is:

Regards,
Antonio