Summary

[tofimoon3]

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]

Hi,

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
Debt'!$A$1:$D$100,2,FALSE)

Where column A of both files contains the common element, the data you want
to lookup is in column 2 of the range A1100 .