how to reference a changing 'last row' cell in a formula

E

EdStevens

I've done this in a vba macro, but now I have a need to do it in a
cell formula.

In my worksheet, a new row of detail is added daily. In the 'header'
area (rows 1 through 10) I have a cell that needs to make a
calculation based on the value of a cell in the most recently added
(last occupied) detail row. In pseudo code it would be something like
this:

=$B(LastRow) * 23.5

Is there an elegant way to do this?

TIA
 

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

Row and column count last occupied cells in range 2
referenceing 'last row' in a cell formula 0
Setting range to last occupied cell 3
VBA CreateNames (ignores last 5 rows?) 6
Insert Row also adds formulas and moves cursor 2
Duplicate last row and other progressive numbers 8
Move rows based on cell info 4
simple code but it doesn't look like usual vba code 2

Top