filling cells with info from other file (unique id)

  • Thread starter Thread starter polletje
  • Start date Start date
P

polletje

I like to know if its possible to get information from an excelfile and
put this in another excelfile using a unique id-number.

When I fill a cell in A-column with for example 12345, I want excel (or
vbamacro?) to look in another file (xls\txt, or?) for 12345 and
transfer the rowvalues to the corresponding columns in the worksheet I
started with.

Can anyone put me in the right direction how to do this? Is it some
standard functionallityu of excel or is it something I have to
program?

Thnx
 
You could use a VLOOKUP formula to extract data from another file. For
example, with an invoice number in cell A2:

=VLOOKUP(A2,'C:\Data\[InvoiceData.xls]Sheet1'!$A$2:$H$26,3,0)
 
Back
Top