Hi,

I don't know what do you mean an example makes it so easy.

Thanks,
--
Farhad Hodjat


"Arain" wrote:

ok i have a sheet where column D thru H need to be auto filled if there is
data for the line above, now the problem is that there are blank rows in the
middle. if its blank it skips it otherwise it copies what ever is in D thru H
if there is data in B column please help me this is about 60000 lrows worth
of data