How to copy a column of values into another column where the cells are merged

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

biancabonilla@gmail.com - 28 Feb 2008 21:17 GMT

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!

Reply to this Message

Pete_UK - 29 Feb 2008 01:47 GMT

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,
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Rate this thread: