Help with SUM cell

hailstorm

New Member
Joined
Sep 14, 2019
Messages
21
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
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,873
Office Version
2013
Platform
Windows
Highlight the range of cells to be copied>>Copy>>Select the first cell on the new sheet >> Paste Special>>ALL
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,012
Office Version
2016
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,057
Messages
5,466,321
Members
406,474
Latest member
osama beskales

This Week's Hot Topics

Top