importing tabs data

[bob]

i'm trying to fiqure out how to take information from one
select tab and column in one tab in import it to another
any ideas?

 

[Gord Dibben]

bob

Several methods for this operation.....

1. Manually copy the column in sheet2 to sheet1.

2. Link sheet1 cells to sheet2 cells. In sheet1 A1 enter =Sheet2!A1 then
drag/copy this down the sheet1 column A.

3. Programmatically....

Sub moveit()
Worksheets("Sheet2").Range("A:A").Copy _
Destination:=Worksheets("Sheet1").Range("A1")
End Sub

Gord Dibben Excel MVP