I have 373 rows that have been merged into 176 cells. On another sheet, I have 176 values, each in its own cell, in a column that I wish to paste into the 176 merged cells.
When I try to paste, it gives me an error - cell must be identical size...
Is there anyway to fix this?
Thanks for your help!
Merged cells are the work of the devil, my friend! Avoid them at all costs.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Yep ... thanks I ended up un merging all cells, and writing a macro to duplicate the first column values, then organizing it using a pivot table.Originally Posted by BB1972
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks