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?

how do I import data from one excel spreadsheet into another?
 

Hi Frank

You would need to create a macro for this yourself.
Switch on the macro recorder, ToolsMacrosRecord new Macro
Carry out the steps of deleting the un-required columns in a copy of
your Raw data, then copying from row 2 onward all of the data that
remains and use Paste SpecialValues to row 2 of your template.
Switch off the Recorder by pressing the large square Stop button.

--
Regards

Roger Govier


"Frank" wrote in message
...
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?