I have 11 columns of that I have been asked to format and reorganized into 1-1/2" x 1/4" box. The only way know how to do this, is by taking the information and manually enter it into a box using Word. There is an example of what I mean in the image that I uploaded with this thread. I am inquiring on how I would go about doing this in a more efficient manor, preferably staying withing excel. Thank you for your time, if this is not the write forum for this topic I am really sorry.
excel.png
Hi Adrian,
Welcome to the Forum!
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 use the paperclip icon to open the upload window.
View Pic
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hey Xladept,
Thanks for the warm welcome. In this response, I have uploaded the files that you asked for. The before file is very similar to the actually document I working with but hundreds of rows, so I took the liberty of slimming it down. The after file is pretty much what I want to be able to do inside excel without having to manually type hundreds of entries.
I think I also desensitized the documents, most the information there can be found on google.
Cheers!
Last edited by adrianpinnock; 07-03-2015 at 06:19 PM.
Hi Adrian,
Try this:
Directions for running the routine(s) just supplied
Please Login or Register to view this content.
If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)
Then - Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
Select "Module" from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
Last edited by xladept; 07-03-2015 at 11:41 PM.
Hey Xladept,
I can't believe you actually were capable of doing this, you are amazing. I thought it was possible, but I honestly didn't think it was something that a complete stranger would be able to help me with. I am just wondering if you would be okay with me editing your script so that the "Zip Code" was on the same line as the rest of the address information.
Thank You,
I honestly was having the hardest time searching for how to do what you just did for me.
Maybe:
Please Login or Register to view this content.
Last edited by xladept; 07-04-2015 at 01:36 PM. Reason: Rewrite of Program
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks