How to add column from worksheet1.xls to column in worksheet2.xls
 

I need to add a column in one worksheet to a column in another worksheet.
How to do??

How to add column from worksheet1.xls to column in worksheet2.xls
 

Not sure what "adding" means.

Assuming your have data in A1 of sheet1 and data in A1 of sheet2

In B1 of sheet2 enter =A1 & sheet1!A1

If you wish a space between enter as =A1 & " " & sheet1!A1

If by "add" you mean "sum"

In B1 enter =SUM(A1,sheet1!A1)

Drag/copy down column B


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 17:15:02 -0700, haidi
wrote:

I need to add a column in one worksheet to a column in another worksheet.
How to do??

Gord Dibben MS Excel MVP