Think it's simpler this way, rather than adjusting the=20
formula in "midstream" when copying across from A2

Yeah, but then what do I do with my "other" data in col C=20
and D below this table?

Biff

-----Original Message-----
Clarification: In Sheet2, if there's nothing to retrieve=20
cols C and D from
Sheet1, and you want the extracts from cols E to H in=20
Sheet1 to appear in
cols C to F in Sheet2, just select and delete the entire=20
cols C and D
*after* you've copied the formula in A2 across to H2 and=20
filled down to
H1000. Think it's simpler this way, rather than adjusting=20
the formula in
"midstream" when copying across from A2

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----


.