Duke,
thanks, your second one:

=IF(INDIRECT("paid!e"&ROW(A1)*4)<"",INDIRECT("pai d!e"&ROW(A1)*4),"")

this worked for my first 3 columns but then didn't when I needed to fill in
the rest of my sheet. How do I fix the columns that need the formula to
reference B5 (instead of B4) from my first sheet and then follow by every 4
intravals like the previous formula I submitted. example: B5, B9, B10
thanks,
angela

"Duke Carey" wrote:

Couple of options:
First:

=IF(OFFSET(Paid!E$4,4*(ROW(A1)-1),0)<"",OFFSET(Paid!E$4,4*(ROW(A1)-1),0)," ")

Second:

=IF(INDIRECT("paid!e"&ROW(A1)*4)< "",INDIRECT("paid!e"&ROW(A1)*4),"")

& copy them down

"amoore" wrote:

Duke,
Thanks, Here is my formula:

=IF(Paid!E4<"",Paid!E4," "), next row: =IF(Paid!E8<"",Paid!E8," ")
and =IF(Paid!B4<"",Paid!B4," "), next row: =IF(Paid!B8<"",Paid!B8," ")

Each column has a different formula, always offset by 4 cells.

Thanks