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

A B
1 Cash & Cash Equivalents 159,100
2 Short-term Financial Instruments 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 Short-term 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?

1) there is no need to manually insert the row first. If you copy a row or
column (or for that matter any number of cells), you can use "insert copied
cells" to paste them into a new row/column (in front of or above a selection)
in one step. If it isn't an entire row or column, Excel will ask if you want
cells pushed down or right to make room for the new info.

2) Excel has some basic database capabilities. You might be able to use those
to simply have the accumulator page display the data from the page where it is
entered the first time.

3) perhaps creating a macro to copy the current line and insert-paste it into
the other sheet at a constant point? (i.e., create a defined row/column line,
and have the macro paste above/in front-of that line each time.) Then it would
be a matter of highlighting the line and running the macro. If you get really
good with macros, it may even be able to figure out which line you want to
copy so you don't need to hi-light it first.

4) consider getting some basic bookkeeping software and transferring to that.
a Google search turns up some free ones:
http://www.google.com/search?num=100...ping&spel l=1
which is tiny'd as: http://tinyurl.com/yylawn




Kent

Natalie.H.Kim (AT) gmail (DOT) com wrote: