Combining multiple cells into one while keeping text formats
I'm currently automating the creation of labels using the formula below:
And while this works fine for combining the information together, it doesn't allow for the user to change the text formatting as there can be hundreds of labels in the end result (there's VBA that cycles through the records and copies the formula value into other cells) so I need a VBA solution but I'm stuck...Could someone help me out please?
Please Login or Register to view this content.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks