B bob Sep 4, 2004 #1 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?
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?
G Gord Dibben Sep 4, 2004 #2 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
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
