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?

In article <1165444937.293549.108440 (AT) n67g2000cwd (DOT) googlegroups.com>,
Natalie.H.Kim (AT) gmail (DOT) com wrote:

Ummm. . . Excel Question. Does not seem like a Filemaker question.

--
For email, change <fake> to <earthlink>
Bill Collins

In article
<bbcollins-12B6EC.10291308122006 (AT) customer-201-125-217-207 (DOT) uninet.net.mx>,
Bill <bbcollins (AT) fake (DOT) net> wrote:

Well, technically you could import all the figures into a Filemaker
system and either do the report there or export it back to Excel ...
but realistically with a report using yearly / annual figures is it
really worth a lot of extra effort? I would simply stick to inserting
the extra rows manually each year, especially since the number of these
extra rows would hopefully decrease fairly rapidly as years go by.

There's not any "easier" way in Excel without also adding a LOT of
extra effort (using Lookups and things) that's really not worth the
trouble, and you're still going to have to add extra rows manually
anyway to be able to type in the new row headings.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)