How to generate Automatic form in excel (mail merge)?

Sandy123 

Well, my help will come in the form of questions.

First, what is it that you are really looking to accomplish at the end of all this? Do you really need 50+ copies of the same spreadsheet, each populated by one of 50+ different records? That doesn't sound very efficient. If you're really creating a form letter (as opposed to just using that as an analog) then Word's Mail Merge, with Excel as the data source, would be the way to go.

If, on the other hand, you need to show these  records for some reason in an Excel format (if, that is, the row and column set up is integral with your goal) then, yes, it would be fairly easy to do using one of several LOOKUP functions or INDEX and MATCH as the basis for extracting the various fields and populating the target sheet. But what, I wonder, is that reason? Why not just create them one at a time as needed?

I (for one) would first be wanting to know why you want to populate 50+ individual sheets with all that data rather than continue to build a single database that can at any time be used to populate another sheet for a nice looking printout. What are you proposing to do with the individualized (or mail-merged) sheets once they're created?

I ask these questions not to be impertinent, but because in my experience with Excel and with seeing others use it, I'd say it's not uncommon that people will create a lot of individual records that end up actually getting in the way of really using Excel well. So I apologize but I feel responsible for trying to ensure that you're using Excel well.