combine data in 2 or more sheets

[Esther]

I have the following problem in combining the data in 2 or more sheets. Currently, is using the 2 windows to compare, add row if needed and cut/paste.

E.g. (Sheet 1)
customer jan feb mar
a 4 5
b 3 2
c 3 1 3

(Sheet 2)
customer apr
a 4
aa 3
c 1
d 3

I hope to combine them into another sheet which will show as follows :
customer jan feb mar apr
a 4 5 4
aa 3
b 3 2
c 3 1 3 1
d 3

Is there a better way as the database is getting bigger? Thanks.

 

[Frank Kabel]

Hi Esther
I would suggest a different spreadsheet layout (to get the most our of
Excel's build-in functionality). Create a master data sheet with the
following layout:
A B C D
1 customer month other info value
2 a Jan '.....' 4
....

So use the month info also as a column. Now you dan use 'Data - Filter'
for filtering specific data, or formulas like sUMIF, COUNTIF to
conditinal sum based on customers or use a pivot table to anaylse your
data. see:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[Jamie Collins]

I have the following problem in combining the data in 2 or more sheets.
Currently, is using the 2 windows to compare, add row if needed
and cut/paste.
E.g. <<snip>>

I think you are discovering for yourself the reason why database
tables are not organized in this way. See the following to fix your
tables:

http://j-walk.com/ss/excel/usertips/tip068.htm

Jamie.

--