# How do I copy columns from one Excel sheet to another?

MmwaggonerNew MemberJoinedAug 9, 2003Messages3Aug 12, 2003#1How do I automatically move a column from one sheet to another in the same workbook? Rather than copy and paste.BBigCWel

M

#### mwaggoner

##### New MemberJoinedAug 9, 2003Messages3

- Aug 12, 2003
- #1How do I automatically move a column from one sheet to another in the same workbook? Rather than copy and paste.B

#### BigC

##### Well-known MemberJoinedAug 4, 2002Messages851

- Aug 12, 2003
- #2Try Cut & Edit / Insert cut cells.

To automate this you'll need to provide more info about fom where, to where,, etc, etc.

HTHM

#### mwaggoner

##### New MemberJoinedAug 9, 2003Messages3

- Aug 13, 2003
- #3I'll have 7 sheets in this workbook. Each of the first 6 sheets will have a column with 100 values in it (B1-B100). As these six sheets are created, I'd like the column of 100 values from each sheet to automatically write to sheet 7. Sheet 7 then would have 6 columns, each 100 cells long. Place these columns as follows: the column from sheet 1 goes to sheet 7, cells A2-A101; the column from sheet 2 goes to sheet 7, cells B2-B101; the column from sheet 3 goes to sheet 7, cells C2-C101; the column from sheet 4 goes to sheet 7, cells D2-D101; the column from sheet 5 goes to sheet 7, cells E2-E101; and the column from sheet 6 goes to sheet 7, cells E2-E101.

I then will need to take these 6 columns of numbers (100 rows of numbers in all) and filter out any duplicate rows (I only want unique rows of numbers) I think I know how to do this filter, just don't know how to have each of the columns that are built on sheets 1-6 to automatically move to sheet 7 without manually cutting and pasteing.B

#### BigC

##### Well-known MemberJoinedAug 4, 2002Messages851

- Aug 13, 2003
- #4As the allignment of columns & cells in each of sheets 1-6 with the column in sheet 7 is consistent, why not just use formulae to reflect the values from each sheet in sheet 7?

That is:

in Sheet7!A2 enter Sheet1!A2

in Sheet7!B2 enter Sheet2!A2

in Sheet7!C2 enter Sheet3!A2

in Sheet7!D2 enter Sheet4!A2

in Sheet7!E2 enter Sheet5!A2

in Sheet7!F2 enter Sheet6!A2

Then copy that range Sheet7!A2:F2 down to A101:F101 provide the table of values required.

In this way, whenever values are entered in Sheets1-6, the values wil be automatically reflected in sheet 7.

HTH