I need to do something similar to what is called a "mail merge" in Word, but in Excel. I have a form in Excel and I want to be able to add information from another data source (also an Excel file). For example, the form I need to fill in has cells such as Name, ID #, Date of Birth, etc, and the data source is a list of members with this information in an excel file.
I tried pasting the form into Word, but it was too large and I couldn't reduce it to fit the page. I also tried creating a chart in Word, but not all of the values came out. Any ideas? I asked earlier, but the suggestions were too complex. Are there any simple solutions?
I tried pasting the form into Word, but it was too large and I couldn't reduce it to fit the page. I also tried creating a chart in Word, but not all of the values came out. Any ideas? I asked earlier, but the suggestions were too complex. Are there any simple solutions?