Office & productivity software forum: I have two data sheet in excel, how to join them together?

really want or need to do.

Do you want to just put all the data in the same workbook ?

Do you want to put part (a couple of fields) of the data from 2011 worksheet into 2012 worksheet ?

Depending on how the data is laid out, pulling selected data entries from one spreadsheet to another is fairly simple.

Lots of possiblities...just not sure how much data you want bring over and how it will be laid out.

VAPCMD

hi,
I want to put part of the data from 2011 worksheet into 2012 worksheet, but also want to pick out the old customers of 2011 from 2012 sheet, and join their consumption details in one sheet. So i can know the old customers consumption trends in the last two years. There are columns like Customer ID (unique number for every customer), Date, Products, Costs.

So can you help me?

Adding the 2011-only customers to the table-of-all-customers is much more difficult.

Kees

online tutorials. Simle enough to try.

VAPCMD

you should download esCalc.

Thanks for your help, i followed u, and get what i want, but i tried twice to get what i want, because i get to use it for the first time~

Hi, kees,

Thanks for your help. Well. it does take much time to do it manually. I will try the MS access, it seems the access is much easier then write codes in VBA...If any problem, do you mind helping me?

Personally, I fiind Access VBA somewhat easier than Excel VBA, but it's more difficult then Excel formulas. So it really depends on the details of the problem- and the experience of the programmer - what's the best choice.

Since it's for business, better hire a programmer if it takes too much time or too much help to do it yourself. It's tax deductable and good for the economy moreover.

Kees