Help with SUM cell

hailstorm

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

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
Joined
Oct 27, 2005
Messages
19,409
Office Version
  1. 2013
Platform
  1. 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,055
Office Version
  1. 2016
Platform
  1. 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,114,608
Messages
5,548,975
Members
410,887
Latest member
sjohn627
Top