Sep 16 2020 07:43 AM
Hi there.
I have an excel document with 4 sheets. I'd like an address from a database (this data base can be turned into an excel sheet) to print on all 4 sheet, in a specific location. On top of that I'd like to make multiple files in the same format but with different addresses. Similar to mail merge in Microsoft Word. How do I do that quickly.
Sep 17 2020 12:12 PM
It's a bit difficult to picture exactly what you're looking for, so what I'm going to suggest may miss the mark entirely. I'm also assuming this is a one-time affair (which is to say, I'm going to give you some steps that probably could be automated at some point via a VBA routine; but I'm not going to go that far).
OK. Here's how I would approach what I think you're describing.
Now, if that doesn't make any sense, come back and clarify what doesn't make sense.
By the way, unless the four spreadsheets are themselves somehow dynamically different for each addressee, is there some other reason why you don't just do this as a MailMerge using Word? You appear to be familiar with it, and it wouldn't require you to do anything fancy with LOOKUP formulas and the like. Word documents can replicate tables and pretty much any other static array of information that Excel can do.