View Single Post
  #8   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

Hi I have a similar task to Mike's and using MS Excel 2003. I have 2
spreadsheet, spreadsheet 1 is updated daily
with NEW DATA NEXT TO THE EXISTING rows OF INFO.
Spreadsheet 2 needs to READ/extract data from ONLY THE ADDITIONAL DATA from
spreadsheet 1. How do I link spreadsheet 2 to spreadsheet 1
so that it will always get the data from 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?