View Single Post
 
Old 08-01-2013, 06:07 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Well, here's what I'm thinking: You've already got it mostly arranged the way you want it, right? You could, at this point, just copy the address column into another worksheet and arrange it for those labels of yours. (As I said, I haven't printed to labels in years so I don't know what's involved in that, but I doubt you need to do much more arranging.) So at this point, you could just get on with the printing and don't need anything more from me. I'm assuming, in saying this, that whatever you have to do won't involve you doing it once for each address—that you can do it en masse, just as you did to get the incoming data whipped into the shape it's in now. I just don't know the details.

On the other hand, if this is going to be repeated—if you're going to have to go get new addresses from somewhere, and arrange them yet again into the current format, perhaps once a week for the next few years—then it's well worth your time to turn the process you've already developed into a VBA program. I can help you with that. But only if you need to ... or if you want to learn VBA just because you think it might be useful.
Reply With Quote