Another option to play around with

In Sheet1, assuming data starts in row2 down

Put in I2: =IF(E2="","",ROW())

Copy I2 down to say, I1000
to cover the max rows that data is expected

In Sheet2
------------
Put in A2:

=IF(ISERROR(SMALL(Sheet1!$I:$I,ROWS($A$1:A1))),"", INDEX(Sheet1!A:A,MATCH(SMA
LL(Sheet1!$I:$I,ROWS($A$1:A1)),Sheet1!$I:$I,0)))

Copy A2 across to H2, fill down to H1000

For a cleaner look, suppress extraneous zeros
from showing in the sheet via:
Tools Options View tab Uncheck Zero values OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Len Canders" wrote in message
...
i have a workbook with two sheets. in sheet1 are rows in which data is
always present/entered for columns a through d and only sometimes in
columns e through h.

what i want to do is: if a row in sheet1 has any data in column e,
then i want to write the data from columns a, b, end e through h of
that row in sheet2, but if column e has no data i do not want to write
any data for that row in sheet2.

can anyone please help with this? i know how to get all data from
sheet1 into sheet2, but i am only interested in some of the data from
sheet1.

thanks in advance.