# Help with SUM cell

#### hailstorm

##### New Member
Hello there

I'm doing something manually but it's taking forever to finish so i would like some help to make it faster. I'm copying cells from sheet2 to sheet1 using the equal sign "=sheet2!A1" in this order:

Column A - Column B - Column C - Column D
=a1 - =a2 - =a3 - =a4
=a5 - =a6 - =a7 - =a8
=a9 - =a10 - =a11 - =a12

I'm still half way to go, so any help is ok! Thanks

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### Michael M

##### Well-known Member
Highlight the range of cells to be copied>>Copy>>Select the first cell on the new sheet >> Paste Special>>ALL

#### footoo

##### Well-known Member
A1 : =OFFSET(Sheet2!\$A\$1,(ROW()-1)*4,0)
B1 : =OFFSET(Sheet2!\$A\$2,(ROW()-1)*4,0)
C1 : =OFFSET(Sheet2!\$A\$3,(ROW()-1)*4,0)
D1 : =OFFSET(Sheet2!\$A\$4,(ROW()-1)*4,0)

Drag down.

Replies
5
Views
37
Replies
13
Views
126
Replies
4
Views
82
Replies
7
Views
53
Replies
13
Views
210