link to last line used

  • Thread starter Thread starter Beacon
  • Start date Start date
B

Beacon

I have a workbook with several sheets. Each sheet has numerous lines that
are filled in on a weekly and or daily basis. The last sheet in the workbook
is a small form that will have the data from the last line used in one of
the other sheets. I want to have excel automatically reference the last line
used on a specific sheet. Any ideas. I prefer to stay away from visual basic
..


There is no living soul that understands all of visual basic!

Thanks
Billy in Virginia
 
Billy will the data be text or numeric?

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Beacon, this will return the last numeric valve in sheet2 column B, will
that do what you want?
=INDEX(Sheet2!B:B,MATCH(9.99999999999999E+307,Sheet2!B:B))
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top