I'm not sure that your requirements are similar to Mike's. Mike wanted only
the last row's data to be reflected over. You seem to want more than that,
besides the orientation differences. If you meant to extract only the last
col's data over from Sheet1, you could try something like this:
Data assumed in Sheet1, row2 down, where the last col of data in each row*
(ie the rightmost cell in each row) is desired to be auto-reflected in Sheet2
in say, col B.
*data may vary from row to row, eg in row2 it may be E2, in row3, its K3,
and so on
In Sheet2,
Put in B2: =LOOKUP(2,1/(Sheet1!2:2<""),Sheet1!2:2)
Copy down as far as required
If the above isn't it, suggest you start your own thread. Illustrate clearly
with sample data what you have in Sheet1, and the expected results in Sheet2.
Do high-five this response by clicking on the YES button below if it helped
in any way
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"vennesse" wrote:
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