dbTalk Databases Forums  

Excel: Combine and match two data

comp.databases.filemaker comp.databases.filemaker


Discuss Excel: Combine and match two data in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Natalie.H.Kim@gmail.com
 
Posts: n/a

Default Excel: Combine and match two data - 12-06-2006 , 04:40 PM






I have two different financial statements for different years (see
below)

A B
1 Cash & Cash Equivalents 159,100
2 ST Financial Instrument 140,000
3 Marketable securities 117,104


A B
1 Cash & Cash Equivalents 200,000
2 Marketable securities 245,123
3 Account receivables 25,345


I want this to look like


A B C
1 Cash & Cash Equivalents 159,100 200,000
2 ST Financial Instruments 140,000 -
3 Marketable securities 117,104 245,123
4 Account receivables - 25,345


The list is very long with different items but I need to combine them.
I have been manually inserting a row to the main sheet, copying and
pasting from the other sheet.


Is there easier way to consolidating the two files into one?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.