Hi,

I have a sheet with a column that lists some values. I also have a
second sheet that has a column where the cells are merged every 4
rows. I need to copy the values of the first sheet into the merged
cells, but when I do, I only see every fourth value on the merged
cells. Is there a formula or any other way that I can use to be able
to copy all the values from the first sheet into the second sheet each
value on a different group of merged cells?

Thanks!

Assume you have values in A1:A5 of Sheet1 that you want to copy into
Sheet2, where A1:A4, A5:A8, A9;A12 etc are merged. Put this formula in
the merged block A1:A4 of Sheet2:

=IF(INDIRECT("Sheet1!A"&INT((ROW(A1)+3)/4))="","",INDIRECT("Sheet1!
A"&INT((ROW(A1)+3)/4)))

Then copy this block into the next block A5:A8, then A9:A12, and so
on.

Hope this helps.

Pete

On Feb 28, 9:17*pm, biancaboni...@gmail.com wrote:
> Hi,
>
> I have a sheet with a column that lists some values. I also have a
> second sheet that has a column where the cells are merged every 4
> rows. I need to copy the values of the first sheet into the merged
> cells, but when I do, I only see every fourth value on the merged
> cells. Is there a formula or any other way that I can use to be able
> to copy all the values from the first sheet into the second sheet each
> value on a different group of merged cells?
>
> Thanks!