Smart Merging
I'm trying to right a piece of code that merge the contents of 'column B'
were the contents of 'column A' is repeated.
I've attached my code below but unfortunately the Offset by one action does not work for me as there can be varios numbers of cells with the sage info.
I've attached an example dats/result set.
Please Login or Register to view this content.
Last edited by TonyforVBA; 10-07-2011 at 11:48 AM.
Try this:-
Regards MickPlease Login or Register to view this content.
If you want to use VBA you should refrain from merging cells (VBA doesn't like them).
An alternative
PS Unfortunately I wasn't able to detect any 'sage' info in the filePlease Login or Register to view this content.
Last edited by snb; 10-07-2011 at 06:39 AM.
I agree, in this instance with snb, there is no such thing as "smart merging" of cells.
However this would appear to do as you ask
Your sample sheet seems to have data validation lists in Column B.Please Login or Register to view this content.
Have a look at "Sheet1 (2)", does the formula solution do what you are after?
(Just a guess.)
Last edited by Marcol; 10-07-2011 at 07:10 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks for you help with that lads. I've got what I neede to get done. Saved me alot of hassle.
Cheers
Are you going to let us into the secret? What saved you a lot of hassle.
Note
You have started 57 threads since you joined the forum, and only one has been marked [SOLVED]. Are all the others unsatisfactory answers?
The only smart merging is no merging!!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hey guys, Sorry I wasnt aware we had to apply a solved status to the threads ourselves I taught it was taken care of my the forum moderators. I'll be sure to do this future.
HOwever . . . I have run into abit of a snag! altough the below code has worked in the tests I carried out it does not appear to work on the spreadsheet I need it for. No error messages, it just merges the wrong cells by the look of things. Would one of you guys mind taking a look, I may be missing somthing quite simple here.
I've attached a copy of the spreadsheet Im working on, with irrelevant content removed.
Cheers
Please Login or Register to view this content.
Sorry, just realised I forgot to attach the file.
Your data in column "F" must be sorted for this to work.
If you can't sort the data for any reason, I suggest you forget about merging cells to get the end result you are looking for, it will cause you all sorts of trouble later.
Merging Cells in Data Tables is a practice to be strongly discouraged.
Thanks Marcol, I actually copped this shortly after putting up the post.
Thanks for you help on this. I'll be sure to mark this as solved.
Enjoy your weekend!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks