This sounds like a spreadsheet question, rather than a programming one. However,
if you want J1 to aleays pick up the last entry in column F, then you can use the
OFFSET function. eg
in J1 put =OFFSET($F$1,COUNTA(F:F)-1,0)
this counts all the items in column F, then points to the last one ( hence the -1)
It won't work though if there are breaks (gaps) in the data, it must be
Youi can also use a UDF - User Defined Function:
Function LastCellVAlue(cl As String)
LastCellVAlue = Cells(65536, cl).End(xlUp).Value
This code will return the value of the last cell used in the selected row,
irrespective of gaps in the list.
Microsoft Excel MVP
What I need is just a simple formula to pick up the last entry in a column
I'm working on a auto mileage chart and I want to export the last entry to
another page, so I can keep up with oil changes.
Also I needed this for a deposit record too!
something perhaps like = (last) or for the mileage chart =(greatest)
I know I made that sound really simple but,only if ya know how, which I
Thanks for some ideas
first visit and looks like I'll be back