Bill, I believe someone posted a way to return the last entry in a column
via formula recently. If you go to http://www.dejanews.com, you will be
redirected to the google newsgroup search engine. You can then search for
that post. Perhaps someone reading kept a copy and can repost for you.
Productivity add-ins and downloadable books on VB macros for Excel
> Let me give another example and a little more info :
> lets say in column "F" I keep my mileage list, which in the case of
> its ever increasing, but not always so with my deposits.
> In "J1 " right now I manually put my last entry from column "F"
> then my other sheet picks this up now, and I then know if its time for
> I'm only going to use maybe 100 or so rows for these entries.
> Will I need the list below or can it be done with just a formula?
> Thanks again And I'll try this tomorrow.
> > Bill, assuming that you have an entry in column A for all rows, you can
> > this row by:
> > dim lastRow as range
> > set lastRow = cells(65536, 1).end(xlup).EntireRow
> > 'above is the same as going way down the sheet and then pressing end, up
> > arrow
> > You can then copy to another sheet:
> > dim destCell as range
> > set destCell = sheets("dest sheet").cells(65536,1).end(xlup).Offset(1,0)
> > lastRow.Copy destCell
> > Bob Flanagan
> > Macro Systems
> > http://www.add-ins.com
> > Productivity add-ins and downloadable books on VB macros for Excel
> > > Hi Everyone
> > > What I need is just a simple formula to pick up the last entry in a
> > > or row.
> > > I'm working on a auto mileage chart and I want to export the last
> > > 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
> > > don't.
> > > Thanks for some ideas
> > > first visit and looks like I'll be back
> > > Bill Czerkie