Hi, I have been working with your instructions but I have not been abl
to get it to work. Any suggetions for VB editor?

thanks, Matt

~× wrote:
*Does the pattern of dates continue? IE:

First sheet -goto -Second Sheet
N1 N1, N2
O1 N3, N4
N2 N5, N6
O2 N7, N8
N3 N9, N10
O3 N11, N12

If so, use this formula in column N on your second sheet.
=INDIRECT(ADDRESS(CEILING((ROW()-1)/4+1,1),IF(MOD(FLOOR(ROW()/2,1),2)=1,14,15))


--
Message posted from http://www.ExcelForum.com