Can you import data into specific cells of an Excel spreadsheet?
 

I've created a template and want to import data into specific cells so that
my charts can automatically display. Is this possible?

Yes - presumming that both files are Excel, open both, go to Window on your
drop down menu and select Arrange and click on tile. If all the data you'd
like to import is consecutive, you can highlight the range, right click and
select copy, then go to your template, right click in the cell you'd like to
bring the data into, select paste special and then paste link. If the cells
aren't consecutive you can import each cell individually using the previous
method, or go into the individual cell and simply enter an operator (either a
+ sign or +sign) then click into the source data and hit enter.
--
tenaj


"Kayh2" wrote:

I've created a template and want to import data into specific cells so that
my charts can automatically display. Is this possible?

Thanks for your response.

Is there an easier way? My template includes a set of ten headings, with
four data fields that need to be imported for each heading. This makes
consecutive headings in groups of four, but the import step would have to be
repeated ten times. That seems a bit tedious.

Is there any kind of formula or macro that would apply---something that
could make this a simple 1-3 click task?


"Tenaj" wrote:

Yes - presumming that both files are Excel, open both, go to Window on your
drop down menu and select Arrange and click on tile. If all the data you'd
like to import is consecutive, you can highlight the range, right click and
select copy, then go to your template, right click in the cell you'd like to
bring the data into, select paste special and then paste link. If the cells
aren't consecutive you can import each cell individually using the previous
method, or go into the individual cell and simply enter an operator (either a
+ sign or +sign) then click into the source data and hit enter.
--
tenaj


"Kayh2" wrote:

I've created a template and want to import data into specific cells so that
my charts can automatically display. Is this possible?