I am hopingyou can help a relative novice at this...
I have an excel based information sheet that we use day to day with some static data and some unique date for a group of people. Each person has their own info sheet.
I want to create a new form for each person en masse by merging the unique data from one spreadsheet into the standard excel sheet - but creating a new sheet each time - pretty much like a Word Mailmerge but using two Excel spreasheets instead.
Does anyone know how if this can be done and if so how?