How to copy into multiple rows from merged cell (or from 1 row)

**birisi** · 08-18-2010, 09:50 AM

Hello,

I have merged cells which are associated with several rows in lots of columns. I would like to copy the values in merged cells into multiple rows which are associated with the merged cells.

With the attached picture, I can explain better: Basically, I want to copy the 'Iso Date' field into the associated 'Date' fields. So The cells B2 - B18 will have 2010-07-17 in them and B19 - B34 will have 2010-07-18 in them, and so on.. The sizes of merged cells vary.

I appreciate if anyone can explain me in detail how to do this. Macro's are also welcome.

Thanks a lot..

**arthurbr** · 08-18-2010, 10:00 AM

Hi

you will find that merged cells are a serious nuisance in excel. So I recommend you get rid of them and place one value in each row.

As for your example, please attach a sample sheet. You cannot expect members to help you based on a picture.

**birisi** · 08-18-2010, 10:16 AM

Hello Arthur,

Thanks for the quick reaction. I have attached a sample file. I have just attached a picture earlier because my problem is quite easy to explain with a picture. Also I don't want a solution for just one case, I prefer a general solution which will work for all cases.

I see that you closed my thread in other forum, I just posted to get help from the Macro Developers as well. I think Macro is necessary in my case and I am not an expert in developing them.

Finally, it's not up to me not to use merged cells, so I have to find a way to deal with them.

Cheers..