Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find, Match data and paste data between two workbooks | Excel Discussion (Misc queries) | |||
How do I combine and match data from 2 sheets | Excel Discussion (Misc queries) | |||
Is it possible to combine MATCH & IF to search an excel sheet | Excel Worksheet Functions | |||
Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions |