how do I import data from one excel spreadsheet into another?
I created a nice template which has all the formatting I like etc.
Once a month I receive a spreadsheet which has all that month's data (which
I refer to as the "raw" data). This spreadsheet has more data (i.e columns)
than I need and uses different column labels than my template.
In short, I want to take the "raw data" and insert it into my template.
Is there a wizard to do this as with, for example, creating a mailing list
from a spreadsheet?
|