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

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