Paste formats and transpose issues.

shreked12

Rules violation
Joined
Mar 14, 2019
Messages
17
Hi

I have a workbook with 6 sheets. Sheets 1-5 I have data in and im copying data into specific cells in sheet 6.

I use paste special- format and also select transpose.

It works fine with sheet 1 when pasting onto sheet 6 but then when trying to copy and paste from sheet 2 onwards it not working.

Any ideas?
 

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

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,336
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
What error messages do you get?
 

shreked12

Rules violation
Joined
Mar 14, 2019
Messages
17
None at all.

I just go onto sheet 2 and copy what I need to transfer over and then do the paste special- format and transpose and it dont do nothing.

I thought it was cos all the data on sheet 6 are in the same column but in different rows but that no different.

What it is ive got rows of about 50 columns all along in sheets 1-5 and trying to copy and paste vertically on sheet . I need it paste special as it linked to other pages and I need sheet 6 auto updating when sheets 1-5 are auto updated from somewhere else.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,336
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
If you are only doing a PasteSpecial formats and transpose you shouldn't get any data transferred to any sheet (including sheet 2).
 

Watch MrExcel Video

Forum statistics

Threads
1,109,453
Messages
5,528,871
Members
409,842
Latest member
mfernandezcean
Top