View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Natalie.H.Kim@gmail.com is offline
external usenet poster
 
Posts: 1
Default Excel: Combine and match two data

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?