#1   Report Post  
Old June 4th 09, 12:45 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
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  
Old June 5th 09, 05:02 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
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 A1100 .

--
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 11:43 AM
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 2 November 7th 05 03:30 PM
multi group with summary above with 1 overall summary line below Freddy Excel Discussion (Misc queries) 1 November 1st 05 08:50 PM


All times are GMT +1. The time now is 06:39 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017