I'm trying to import fields from one Excel file to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to import certain fields from one Excel spreadsheet to another.

For example:

Spreadsheet A is a template with about 15 fields that need to be updated.
Spreadhsheet B has the information I need to plug into Spreadsheet A.

So, what I want is to tell Spreadsheet A to go to Spreadsheet B and get THIS
data from Spreadsheet B and input it into THAT field on Spreadsheet A... and
so on and so on...

Am I making any sense here?
 
Click in the destination cell in sheet A, type =, go to sheet B, click in
the source cell. Enter.
Correspondingly for your other cells.
 
You must log in or register to reply here.

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Alt codes 4
Lookups - how to obtain data from a master spreadsheet into another 5
can you create nested formulas within v-lookup; if so how 1
Copy columns, but not hidden ones 3
comparing columns in two spreadsheets 1
Quick way for monthly linking of Excel sheets 0
Embedding check boxes into Excel cells 0

Back
Top