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
If this helps, please click the Yes button.
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.