Import External Data to template format 2007

L

LauraJ

In Excel 2003, I could import data from one Excel worksheet into another
(with format from template), and the data would inherit the formatting of the
template and display accordingly. I can't for the life of me figure out how
to do this in Excel 2007. In 2003, one could set the External Data Range
Properties prior to importing data -- in 2007 this doesn't seem to be the
case. I am able to import the necessary data, but the format is all wrong.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top