filling cells with info from other file (unique id)

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
 
D

Debra Dalgleish

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)
 

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

Merging from an Excel file with graphics 1
Load JPG from Web 0
Assignment Unique ID Different in Extract Map 0
Closing Excell from Access 3
Fill in columns by matching a value on another sheet 3
Can the IF function be used with values from multiple worksheets? 4
Setting up macro betwen two sheets 1
"Sumif" not working consistently 1

Top