View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
vennesse vennesse is offline
external usenet poster
 
Posts: 10
Default Linking 2 spreadsheet using data from the last row of spreadsh

I have a similar task and am using MS Excel 2003. I have 2 spreadsheet,
spreadsheet 1 is updated daily DEPENDING ON THE DATA (ROWS). Spreadsheet 2
needs to extract data from the last UPDATED ROW OF DATA FRM SPREADSHEET 1.
How do I link spreadsheet 2 to spreadsheet 1
so that it will always get the data FROM ANY ROWS THT HAVE BEEN UPDATED of
spreadsheet 1 automatically?

VENNESSE

"Max" wrote:

Assume the "last row of data" is determined in Sheet1's col A
In Sheet2,
you could use something like this in say, A2:
=LOOKUP(2,1/(Sheet1!$A$2:$A$100<""),Sheet1!A2:A100)
to extract the last row value in Sheet1's col A. Copy A2 across to return
the other cols' values (ie col B, col C, etc) for that last row in Sheet1's
col A
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Mike" wrote:
I'm using MS Excel 2003. I have 2 spreadsheet, spreadsheet 1 is updated daily
with new rows added daily. Spreadsheet 2 needs to extract data from the last
row of data from spreadsheet 1. How do I link spreadsheet 2 to spreadsheet 1
so that it will always get the data from the last row of spreadsheet 1
automatically?