link to last line used

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
 
P

Paul B

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 **
 
P

Paul B

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 **
 

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

Top