#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Summary


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.




--
tofimoon3
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default Summary

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 A1:D100 .

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"tofimoon3" wrote:


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.




--
tofimoon3

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summary help! ml Excel Worksheet Functions 3 July 24th 08 07:12 PM
Summary using VBA Ananth Excel Discussion (Misc queries) 1 July 5th 07 08:36 AM
Summary SUM Ananth Excel Discussion (Misc queries) 5 March 13th 07 12:43 PM
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 2 November 7th 05 04:30 PM
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 1 November 1st 05 09:50 PM


All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"