Dear sir,with best regards,in attached file i have two schedules ,one
for details of the invoices contents and the second for ( summary) of
these contents . i ask you kindly the way ( by formulas or codes) to
transfer the data from schedule 1 to be as mentioned in 2.
Thanks in advance.

Shane Devenshire


If you have a common field in both files then use VLOOKUP, look this up in
the help system.

We can't see your files so its just a guess what the look like. The general
form of the formula would be:

=VLOOKUP(A1,'[Chapter 07 - Printing Charts.xls]National

Where column A of both files contains the common element, the data you want
to lookup is in column 2 of the range A1:D100 .
Apr 29, 2007
Reaction score
Dear sir,with my regards,i think the solution without taking a look to the example is difficult ,and because you have no time for this.

I ask you kindly to consider the matter as solved.
Thanks again.

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

Table summary 0
#VALUE! problem 2
blank cells 0
sheets 4
Formula Help PLEASE!!!! 1
sheets 1
Copy summary data to new sheet 1
cells protection 2