Help me please...

G

Giacomo

Dear friends... I need a real help...
I'm italian and I hope you can understand my poor english...

I have 3 files .xls
In the first one (A) I have an index of materials and of their codes, the
second one (B) is linked to A.
If I put a code in B1 I obtain in B2 the name of the correspondenting
material that is in A.
Where's the problem????
In the third file (C...I have a lot of file C) I have a very big list of
materials and I would like to transfer automatically all the materials in B
with a macro that could be this one...

1 read the material code in C
2 copy the code
3 put it in B1

Is this possible????
Thanx a lot for your patience and sorry for my ignorance in VB
programming....

Giacomo
 
A

Angelikoula

Buongiorno Giacomo (this is as far as my Italian goes)

You can do this by using the VLOOKUP function. If you want to attach
samples of the three files here (not with the whole lists of materials,
just a few records) I can do it for you and explain how it's done.
 

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

Help with multi-level list 0
slow code with many loopings 6
popup immage 1
Invoice 8
Very difficult mathematical-iteration problem for engineers!!!!!! 2
Formula help, please. 3
VLookUp Function 3
Help me for exact Formula 3

Top