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

H

haidi

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

Gord Dibben

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

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

Gord Dibben MS Excel MVP
 
Top