Thread: Worksheet to Worksheet Information
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Worksheet to Worksheet Information
Something like this ..
In Sheet2,
In say, B2: =LOOKUP(2,1/(Sheet1!A1:A65535<""),Sheet1!A1:A65535)
will return Sheet1's last data cell in colA
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Bundy" wrote:
I should have added that the column I want the last cell from is regularly
added to...so I want the LAST cell added each time to show in a cell on the
other worksheet.

Reply With QuoteReply With Quote