Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference multiple cells in if statement | Excel Worksheet Functions | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Autofill data in specific blank cells | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |