"Miloann" wrote
What if I want to save the extracted records into a new spreadsheet?
Assume source txn data is in Sheet1, from A1 down
In another sheet, say Sheet2:
Input the source sheetname in A1: Sheet1
Input the row start number in B1, say: 3
Then we could put in C1, the revised:
=OFFSET(INDIRECT("'"&$A$1&"'!A"&$B$1),ROW(A1)*30-30,)
and copy C1 down to C2000, as before
The above will extract the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---