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