Merge Sheets - Information

[akber.431]

Can anyone help me in the Merge Sheets

I have two Excel Sheets having details of Customer Sales & Receipts


Sheet#1 : Contain Customer Sales Record with following Rows :[/U]
A - Invoice#
B- Invoice Date
C- Month
D- Cust. No.
E- Area Code
F- Area Name
G- Customer name
H- Sales Amount


Sheet # 2 Contains Customer Reciepts :
A -Month
B- Customer No.
C- Area
D-Customer Name
E-Date
F-RV#
G- Amount

the above details i have , Actually i want to see the Customer Sales (Month wise and Receipts (by months breakup) in one excel sheet with the help of customer code no.
how can i merge this information to get my desired results. any suggestion on this issue will be appreciated

thanks & regards
Akber Ali

 

[Gary McMaster]

Here's one way that will probably work using MSQuery to link the customer code numbers. Please note that the author is using Excel sheets as database tables.

http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/mgmt_queries.html

Gary

 

[akber.431]

thanks for your reply,

if it could be more helpful if you give me an idea in Excel, bcz its very difficult to understand the database query , even i m not not getting the exact result



thanks

 

[Gary McMaster]

even i m not not getting the exact result

It can be tricky but it does work. I've used the technique(s) described on that site many times.

Here is some info and code samples from Microsoft about combining sheets:

http://msdn.microsoft.com/en-us/library/cc793964.aspx

If you search this forum for "Combine" or "Merge" you should find numerous other examples.

Gary