LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?

 
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
Find, Match data and paste data between two workbooks Chuckak Excel Discussion (Misc queries) 0 September 1st 06 06:59 PM
How do I combine and match data from 2 sheets CathyW Excel Discussion (Misc queries) 3 March 23rd 06 10:18 PM
Is it possible to combine MATCH & IF to search an excel sheet Callan Excel Worksheet Functions 1 October 28th 05 01:45 PM
Match and index functions: corrlating data from 2 worksheets [email protected] Excel Worksheet Functions 2 May 21st 05 05:38 AM
Find a match that;s not exact Phyllis Excel Worksheet Functions 0 November 8th 04 08:12 PM


All times are GMT +1. The time now is 12:21 PM.

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

About Us

"It's about Microsoft Excel"