How to automatically display current row # without typing in the number manually?

D

dougmcc1

When I copy the data in my worksheet and paste it into other cells, the
cell numbers in my functions get changed wrong and I have to go through
and manually change every single one, and there are hundreds of them.

The cell number in each function is equal to the row that the cell
function is in. So say my function is in cell C5, and the function is:
=(stuff)C5. Then I copy the function and paste it into cell C20 but
the function still says =(stuff)C5 instead of =(stuff)C20 like it
should.

Is there a way to replace C5 with whatever the current row is? Is there
something like &ROW, or !ROW for example?

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - disable automatic function 4
Insert Row - Stop Automatic Formula Update 1
Populating Row with dates 1
Referencing cells in consecutive rows 2
How to reference or redirect a formula in a base row? 3
Summing from multiple wksts - incomprehensible #VALUE error 9
Insert Index into a Table 1
Keep formatting while using drop-down list 3

Top