"Max" wrote:
I also have a similar task and using MS Excel 2003.
I have 2 spreadsheet, spreadsheet 1 is updated daily
with new DATA ADDED NEXT TO THE ROWS OF DATA daily. Spreadsheet 2 needs to
extract THE UPDATED data from the rows of data from spreadsheet 1. How do I
link spreadsheet 2 to spreadsheet 1
so that it will always get the ROW OF data from the row of spreadsheet 1
automatically?
The new data are usually not updated in order.
EX: Column B to E are populated with information and DATA updated in F
through M.

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?

Hi Venesse

Are you saying that columns B:E are constant on Sheet1, with new data being
entered in columns F:M which overwrites what was there before?

If so, and assuming your Sheet 2 has values in column A that match column A
of Sheet 1, then it is enter in B2 of Sheet2
=VLOOKUP($A2,Sheet1!$A$:$M$,Column(F2),0)
Copy across and down as far as required


--
Regards
Roger Govier

"vennesse" wrote in message
...


"Max" wrote:
I also have a similar task and using MS Excel 2003.
I have 2 spreadsheet, spreadsheet 1 is updated daily
with new DATA ADDED NEXT TO THE ROWS OF DATA daily. Spreadsheet 2 needs
to
extract THE UPDATED data from the rows of data from spreadsheet 1. How do
I
link spreadsheet 2 to spreadsheet 1
so that it will always get the ROW OF data from the row of spreadsheet 1
automatically?
The new data are usually not updated in order.
EX: Column B to E are populated with information and DATA updated in F
through M.

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?